Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic message
How do I create an automatic message that will be displayed everytime a
particular file is opened? |
#2
|
|||
|
|||
Hi Kanye
You can put code against the Workbook_Open procedure in the ThisWorkbook module ... open your workbook, press ALT & F11 to get to the VBE window in the project explorer (view / project explorer) under your file (the name will be bold & in brackets), you'll see all your sheets listed and then something called ThisWorkbook double click on it, from the left hand side drop down box on the right hand side of the screen, choose workbook and the Private Sub Workbook_Open() End Sub will be created for you - put your code in here. However, for the code to run - tools / macro / security needs to be set to medium (or low, but don't recommend this) and if you're asked you need to enable macros on opening the file. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "kanye" wrote in message ... How do I create an automatic message that will be displayed everytime a particular file is opened? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Font error message | Charts and Charting in Excel | |||
changing the message in an error message | Excel Worksheet Functions | |||
Excel error message | Excel Discussion (Misc queries) | |||
Pivot Table not valid error message when formatting data 'button'. | Excel Discussion (Misc queries) | |||
Error Message appearing when saving a file | Excel Discussion (Misc queries) |