Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 64
Default Message that opens when file is opened

Hi - I'd like to create a message (on a form, I guess) that automatically is
opened as soon as a specific file is opened. I was hoping someone could
provide me with suggestions on how to do this or even the code they think
would be needed to do this.

Thanks,

Robert
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,758
Default Message that opens when file is opened

You can use a procedure named Auto_open in a general module:

Option Explicit
Sub Auto_Open()
msgbox "Hi from this here workbook!"
end sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Linking to specific cells in pivot table wrote:

Hi - I'd like to create a message (on a form, I guess) that automatically is
opened as soon as a specific file is opened. I was hoping someone could
provide me with suggestions on how to do this or even the code they think
would be needed to do this.

Thanks,

Robert


--

Dave Peterson
Reply
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
Excel file opens and opens and opens Wanna Learn Excel Discussion (Misc queries) 1 June 9th 09 11:03 PM
how can I create a pop-up message whenever a workbook is opened? twiftshoeblade Excel Discussion (Misc queries) 4 August 20th 08 11:32 PM
message box when file is opened oxicottin Excel Worksheet Functions 5 January 13th 07 12:47 AM
Display a message when a file is opened. Sheila New Users to Excel 4 November 15th 05 05:14 PM
Message when workbook is opened Ian[_9_] Excel Programming 2 August 5th 04 03:39 PM


All times are GMT +1. The time now is 07:28 PM.

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"