#1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5
Default Message Box

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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,646
Default Message Box

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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5
Default Message Box

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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,646
Default Message Box

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
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
Pop up message HRlady Excel Worksheet Functions 1 April 22nd 07 10:14 PM
If then Message Box Nikki Excel Discussion (Misc queries) 8 December 22nd 05 02:41 PM
changing the message in an error message The Villages DA Excel Worksheet Functions 2 February 18th 05 05:30 PM
message box swec74 Excel Worksheet Functions 5 January 8th 05 08:55 PM
message box Monty Excel Worksheet Functions 10 December 24th 04 02:26 PM


All times are GMT +1. The time now is 09:11 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"