LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 26
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Retaining formats grok Excel Discussion (Misc queries) 11 October 31st 06 07:29 PM
different values depending on how text file is opened notMe Excel Discussion (Misc queries) 6 September 14th 06 08:43 AM
importing a particular excel worksheet into another excel file dinouk Excel Worksheet Functions 0 August 10th 06 02:03 PM
My excel file is locked for editing. How do I get it opened. DaveyOLostWages Excel Worksheet Functions 2 July 30th 06 05:12 PM
Adding an error message at close of file when criteria are met Dave Excel Discussion (Misc queries) 3 August 12th 05 07:56 PM


All times are GMT +1. The time now is 11:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"