Message Open Box
 

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

Message Open Box
 

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.

If you rule out macros it might not be possible. You could save the
workbook with a sheet active that has your message text prominently
displayed in it. Of course the user could then save it with another sheet
active, but at least he would have seen the message once.

--
Jim Rech
Excel MVP

Message Open Box
 

The usual way of handling this is to hide/password protect everythin
except for a sheet that tells users they must enable macros to use th
workbook.

If they have macros enabled, there is no need for them to see it

--
Message posted from http://www.ExcelForum.com

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