Password protected sheet
 

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

Password protected sheet
 

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.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Password protected sheet
 

On Nov 16, 11:17*am, GS wrote:
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.

--
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

Password protected sheet
 

Johnnyboy5 laid this down on his screen :
On Nov 16, 11:17*am, GS wrote:
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.

--
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

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

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc