View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_5_] GS[_5_] is offline
external usenet poster
 
Posts: 226
Default 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