Password protected sheet

[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

 

[GS]

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

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]

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

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

 

[GS]

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

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