Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error message on open | Excel Discussion (Misc queries) | |||
auto open message | New Users to Excel | |||
Create a message to 'pop open' | Excel Discussion (Misc queries) | |||
linked PDF will not open "can not open specified file" is message | Excel Discussion (Misc queries) | |||
want to create a message box to appear on open | Excel Discussion (Misc queries) |