Thread: Password To Open Spreadsheet Used as Variable in VB Code or Macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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.

Reply With QuoteReply With Quote