Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password To Open Spreadsheet Used as Variable in VB Code or Macro
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password To Open Spreadsheet Used as Variable in VB Code or Macro
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 On Tue, 16 Mar 2010 14:12:02 -0700, DogLover wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password To Open Spreadsheet Used as Variable in VB Code or Ma
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? "Gord Dibben" wrote: 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 On Tue, 16 Mar 2010 14:12:02 -0700, DogLover wrote: 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to open Excel spreadsheet when forgotten password | Excel Discussion (Misc queries) | |||
How to open Excel spreadsheet when forgotten password | Excel Discussion (Misc queries) | |||
How can I open an excel spreadsheet if I forgot the password? | Excel Worksheet Functions | |||
open excel spreadsheet with password | Excel Programming | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) |