Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hiya,
I was wondering if the following is possible with Excel 2000 I would like to see an comments/message box appearing when an Excel sheet is being opened. Basicly I want that when someone opens an (log file) excel sheet a messages appears saying please update this or that before they can go on with the sheet it self, it is like a reminder. Kind regards, Mr.WJCA |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Place
MsgBox "messagetext" in Workbook_Open() event sub! Post if you need help to instaal it! Regards, Stefi MR.WJCA ezt *rta: Hiya, I was wondering if the following is possible with Excel 2000 I would like to see an comments/message box appearing when an Excel sheet is being opened. Basicly I want that when someone opens an (log file) excel sheet a messages appears saying please update this or that before they can go on with the sheet it self, it is like a reminder. Kind regards, Mr.WJCA |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi Stefi,
That is a nice tip. But is something like this also possible without running a macro? "Stefi" wrote: Place MsgBox "messagetext" in Workbook_Open() event sub! Post if you need help to instaal it! Regards, Stefi MR.WJCA ezt *rta: Hiya, I was wondering if the following is possible with Excel 2000 I would like to see an comments/message box appearing when an Excel sheet is being opened. Basicly I want that when someone opens an (log file) excel sheet a messages appears saying please update this or that before they can go on with the sheet it self, it is like a reminder. Kind regards, Mr.WJCA |
#4
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Maybe you can attach a constantly displayed comment to a cell, say A1.
Stefi MR.WJCA ezt *rta: Hi Stefi, That is a nice tip. But is something like this also possible without running a macro? "Stefi" wrote: Place MsgBox "messagetext" in Workbook_Open() event sub! Post if you need help to instaal it! Regards, Stefi MR.WJCA ezt *rta: Hiya, I was wondering if the following is possible with Excel 2000 I would like to see an comments/message box appearing when an Excel sheet is being opened. Basicly I want that when someone opens an (log file) excel sheet a messages appears saying please update this or that before they can go on with the sheet it self, it is like a reminder. Kind regards, Mr.WJCA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pop up message | Excel Worksheet Functions | |||
If then Message Box | Excel Discussion (Misc queries) | |||
changing the message in an error message | Excel Worksheet Functions | |||
message box | Excel Worksheet Functions | |||
message box | Excel Worksheet Functions |