View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Message Open Box

Not really.

Many recommend hiding all your sheets and having one sheet visible with a
big message on it. If macros are enabled, the macro would unhide the
appropriate sheets and set up the workbook. If macros are disabled, only
the big message is readily available. One disadvantage of this is that
when macros are enabled, when the workbook is closed, they would need to
rehide all the sheets and save the workbook. This would make it difficult
for the user to quit without saving changes, which is often a useful
capability if a big mistake is made.

also, Excel is really designed to be a development platform, so it security
features are easily broken and are really intended only as a convenience to
help the user from making inadvertent changes.

--
Regards,
Tom Ogilvy

"RC" wrote in message
...
I have read within the questions and used the command to have a message

box
show automatically when a file is opened.

Start VBA
In the ThisWorkBook module, enter:
Private Sub Workbook_Open()
MsgBox ("Blah Blah Blah")
End Sub

However, its not quite foolproof as the user has an option to enable or
disable the macro at file open stage. If they disable the macro - they

don't
see the message.
Is there any other way of showing a message on file open that does not

give
the user an option to disable it and therefore miss the message.

Thanks

Ron