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
|