Hope someone can help me with this.
I have a workbook with 3 sheets.
One is a sheet where I fill in some information about a project, sheet is called Info
The other 2 sheets are kind of templets and named, Dag vs. 12.1-Styrd Borrning.
These sheets are normally hidden and parts of them are locked with password.
On the Info sheet I have 2 buttons and I want to attach a macro to each one of them.
It should unhide the template sheet 12.1-Styrd Borrning, unlock the password, copy the sheet, place it to the right side of the Info tab (that is always as number 4), name the new tab as 12.1-Styrd Borrning 1, lock the password, hide the template sheet again.
Next time I press my button (activate the macro) it should give me a new sheet again, placed as number 4 but this time named 12.1-Styrd Borrning 2, and so on..
On the Info sheet next to the button I also have a box in O14:V14 that should show the number of pages I have of 12.1-Styrd Borrning in the workbook.
Much appreciated if someone could find a few minutes to help me solve this.