| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
message box when file is opened
Hello I have been serching around in this forum and dont really understand
how to do this. I want a pop up message to open when an .xls file is opened. I did find someone wrote this. But I dont know how to do this I never messed with macro ect. Can someone explaing in depthe how this is done? Thanks!!!!! putn the following code in yopur workbook module ('ThisWorkbook'): sub workbook_open() msgbox "Now opening..." end sub |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
message box when file is opened
Hi oxicottin
Alt F11 to open the editor To be sure you see all windows press one time Ctrl-R and F7 Double click on the ThisWorkbook module on the left in the project window If you not see it click on the + before the project/file name Then paste this in the code window Private Sub Workbook_Open() MsgBox "Hi" End Sub Then use Alt q to close the editor Save/close and reopen the file now -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "oxicottin" wrote in message ... Hello I have been serching around in this forum and dont really understand how to do this. I want a pop up message to open when an .xls file is opened. I did find someone wrote this. But I dont know how to do this I never messed with macro ect. Can someone explaing in depthe how this is done? Thanks!!!!! putn the following code in yopur workbook module ('ThisWorkbook'): sub workbook_open() msgbox "Now opening..." end sub |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
message box when file is opened
works great! Is there some way I can make my box larger?
"Ron de Bruin" wrote: Hi oxicottin Alt F11 to open the editor To be sure you see all windows press one time Ctrl-R and F7 Double click on the ThisWorkbook module on the left in the project window If you not see it click on the + before the project/file name Then paste this in the code window Private Sub Workbook_Open() MsgBox "Hi" End Sub Then use Alt q to close the editor Save/close and reopen the file now -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "oxicottin" wrote in message ... Hello I have been serching around in this forum and dont really understand how to do this. I want a pop up message to open when an .xls file is opened. I did find someone wrote this. But I dont know how to do this I never messed with macro ect. Can someone explaing in depthe how this is done? Thanks!!!!! putn the following code in yopur workbook module ('ThisWorkbook'): sub workbook_open() msgbox "Now opening..." end sub |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
message box when file is opened
Hi oxicottin
No, if you want that you must create a userform and open that when your workbook start. What do you want to do, splash screen ? See http://www.j-walk.com/ss/excel/tips/tip39.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "oxicottin" wrote in message ... works great! Is there some way I can make my box larger? "Ron de Bruin" wrote: Hi oxicottin Alt F11 to open the editor To be sure you see all windows press one time Ctrl-R and F7 Double click on the ThisWorkbook module on the left in the project window If you not see it click on the + before the project/file name Then paste this in the code window Private Sub Workbook_Open() MsgBox "Hi" End Sub Then use Alt q to close the editor Save/close and reopen the file now -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "oxicottin" wrote in message ... Hello I have been serching around in this forum and dont really understand how to do this. I want a pop up message to open when an .xls file is opened. I did find someone wrote this. But I dont know how to do this I never messed with macro ect. Can someone explaing in depthe how this is done? Thanks!!!!! putn the following code in yopur workbook module ('ThisWorkbook'): sub workbook_open() msgbox "Now opening..." end sub |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
message box when file is opened
No I was just woundering! Is it possible to change the text color?
"Ron de Bruin" wrote: Hi oxicottin No, if you want that you must create a userform and open that when your workbook start. What do you want to do, splash screen ? See http://www.j-walk.com/ss/excel/tips/tip39.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "oxicottin" wrote in message ... works great! Is there some way I can make my box larger? "Ron de Bruin" wrote: Hi oxicottin Alt F11 to open the editor To be sure you see all windows press one time Ctrl-R and F7 Double click on the ThisWorkbook module on the left in the project window If you not see it click on the + before the project/file name Then paste this in the code window Private Sub Workbook_Open() MsgBox "Hi" End Sub Then use Alt q to close the editor Save/close and reopen the file now -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "oxicottin" wrote in message ... Hello I have been serching around in this forum and dont really understand how to do this. I want a pop up message to open when an .xls file is opened. I did find someone wrote this. But I dont know how to do this I never messed with macro ect. Can someone explaing in depthe how this is done? Thanks!!!!! putn the following code in yopur workbook module ('ThisWorkbook'): sub workbook_open() msgbox "Now opening..." end sub |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
message box when file is opened
No, use a userform if you want that
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "oxicottin" wrote in message ... No I was just woundering! Is it possible to change the text color? "Ron de Bruin" wrote: Hi oxicottin No, if you want that you must create a userform and open that when your workbook start. What do you want to do, splash screen ? See http://www.j-walk.com/ss/excel/tips/tip39.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "oxicottin" wrote in message ... works great! Is there some way I can make my box larger? "Ron de Bruin" wrote: Hi oxicottin Alt F11 to open the editor To be sure you see all windows press one time Ctrl-R and F7 Double click on the ThisWorkbook module on the left in the project window If you not see it click on the + before the project/file name Then paste this in the code window Private Sub Workbook_Open() MsgBox "Hi" End Sub Then use Alt q to close the editor Save/close and reopen the file now -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "oxicottin" wrote in message ... Hello I have been serching around in this forum and dont really understand how to do this. I want a pop up message to open when an .xls file is opened. I did find someone wrote this. But I dont know how to do this I never messed with macro ect. Can someone explaing in depthe how this is done? Thanks!!!!! putn the following code in yopur workbook module ('ThisWorkbook'): sub workbook_open() msgbox "Now opening..." end sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retaining formats | Excel Discussion (Misc queries) | |||
| different values depending on how text file is opened | Excel Discussion (Misc queries) | |||
| importing a particular excel worksheet into another excel file | Excel Worksheet Functions | |||
| My excel file is locked for editing. How do I get it opened. | Excel Worksheet Functions | |||
| Adding an error message at close of file when criteria are met | Excel Discussion (Misc queries) | |||
Linear Mode
