Password To Open Spreadsheet Used as Variable in VB Code or Macro

D

DogLover

I would like to set a variable to be 1 of 7 values based on what password is
used to open a spreadsheet. Does any know if this is possible?? If so,
please provide some helpful hints.

Thanks for your help.
 
G

Gord Dibben

How do you set more than one password to open a workbook?

Or do you mean password after opening?

Like a password to access a certain sheet in the workbook?


Gord Dibben MS Excel MVP
 
D

DogLover

Now that you mention it, I probably can only use 1 password to open the
workbook. Would the be a way to have the user have to type in a password on
the open event, and then pass this as a public variable that could then be
used?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
VBA word change keys 0
Protected word template - vb/macro to update footer 7
VBA Coding Help for Beginner 0
Use Value of Dynamically Created Variable 5
Best Practice for Public Variables for Column Headings 2
Open to modify 3

Top