Public password

[dpaton05]

I have a spreadsheet I want to password protect to stop users from wrecking it accidentally.

In the code behind one of the sheets I want protected, I have the following code at the top of that sheet

Option Explicit
Const ToUnlock As String = "word"

Can that code only be used for procedures in that sheet or is it a global thing, being able to be used anywhere?

After some trial and error, I have found it only works for that section the code is stored. How can I write the code so that the constant I store the password in is a global thing so I only need to update it once?

 

[Michael M]

Add "public" to the front to fo Const String

 

[Michael M]

Have a read here Dave for different levels of Constants

VBA Declare Constant with Const and Public Const - wellsr.com

You should declare constants in VBA when you need a value defined and you know the value won't change. You declare constants using VBA Const and Public Const.

wellsr.com

 

[dpaton05]

Thanks for that Michael, I will have a look.