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

I need to display a message when a workbook is opened.
I've never done any coding in Excel so can someone give me
some pointers. Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Message when workbook is opened

Private Sub Workbook_Open()
MsgBox "Hi!"
End Sub

"Ian" wrote:

I need to display a message when a workbook is opened.
I've never done any coding in Excel so can someone give me
some pointers. Thanks!

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Message when workbook is opened

Thanks. The only problem is that I get the "....contains
macros" message also. Is there a way to disable that?
-----Original Message-----
Private Sub Workbook_Open()
MsgBox "Hi!"
End Sub

"Ian" wrote:

I need to display a message when a workbook is opened.
I've never done any coding in Excel so can someone give

me
some pointers. Thanks!

.

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
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
how can I have a message displayed when a spreedsheet is opened ? dleus Excel Discussion (Misc queries) 2 May 17th 08 05:09 PM
message box when file is opened oxicottin Excel Worksheet Functions 5 January 13th 07 12:47 AM
how do i create a start up message each time a document is opened? Dane Excel Discussion (Misc queries) 1 September 13th 06 03:00 AM
Display a message when a file is opened. Sheila New Users to Excel 4 November 15th 05 05:14 PM


All times are GMT +1. The time now is 05:54 PM.

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

About Us

"It's about Microsoft Excel"