View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Linking to specific cells in pivot table Linking to specific cells in pivot table is offline
external usenet poster
 
Posts: 64
Default Need a psswd verification form to open when the file is opened

Hi - I'd like to do the following and am hoping to get guidance on how to do
this:

- Create a form which asks the user to input a password -- if the password
is correct, the user is able to access the spreadsheet. If the password is
incorrect, the user is not able to access the spreadsheet.

- Have the form described above automatically open when the file is opened.

I have a created a form in VB, but am honestly not sure how I should
approach the password issue and then how to get it to automatically pop up
when the file is opened (I'm assuming I can initiate the form under 'Option
Explicit', but haven't been able to figure out the sytax for initiating a
form there).

Any help you can provide is appreciated!

Robert