I have a course booking spreadsheet that has a BeforeClose procedure that now works well.
I am trying to see if I can set it up as a template for other courses.
There are 3 variables in the code which I would like the code to get from named cells on the spreadsheet
I think that if I can get help to get the first one, the password, sorted then I should be able to figure out the rest.
The name of the cell for the password is Worksheet_Password.
The current line of code for the password protection is -
ActiveSheet.Unprotect Password:="SHES"
How can I make it go to the named Worksheet_Password cell for the password rather than having to write it in the code?
I am trying to make this workbook simple for the end user so that they do not have to alter the code
I am trying to see if I can set it up as a template for other courses.
There are 3 variables in the code which I would like the code to get from named cells on the spreadsheet
I think that if I can get help to get the first one, the password, sorted then I should be able to figure out the rest.
The name of the cell for the password is Worksheet_Password.
The current line of code for the password protection is -
ActiveSheet.Unprotect Password:="SHES"
How can I make it go to the named Worksheet_Password cell for the password rather than having to write it in the code?
I am trying to make this workbook simple for the end user so that they do not have to alter the code