Password protected sheet

  • Thread starter Thread starter Johnnyboy5
  • Start date Start date
J

Johnnyboy5

Hi

I need to be able to get a message box to appear with some information
- before the Password message box appears. I can get the message to
appear after the Password box - but not before any ideas.

Johnnyboy
 
Johnnyboy5 presented the following explanation :
Hi

I need to be able to get a message box to appear with some information
- before the Password message box appears. I can get the message to
appear after the Password box - but not before any ideas.

Johnnyboy
Click to expand...

If you're referring to the user clicking the protect/unprotect menu
item, you could 'hook' that to a macro. To do this, write your own
procedure and assign it as the macro (OnAction) that runs when clicked.
Now you can display your message before displaying any password
dialogs.
 
Johnnyboy5 presented the following explanation :




If you're referring to the user clicking the protect/unprotect menu
item, you could 'hook' that to a macro. To do this, write your own
procedure and assign it as the macro (OnAction) that runs when clicked.
Now you can display your message before displaying any password
dialogs.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc
Click to expand...

Hi

No its not about that - its when the file is first openned - and the
password dialog box asked for the password or to open it as read only
- I want run a message before the "password" dialog box opens.

ta

Johnnyboy
 
Johnnyboy5 laid this down on his screen :
Hi

No its not about that - its when the file is first openned - and the
password dialog box asked for the password or to open it as read only
- I want run a message before the "password" dialog box opens.

ta

Johnnyboy
Click to expand...

Ok, so your topic should say "workbook open password protected".
 
Back
Top