Message Box

M

MR.WJCA

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
 
S

Stefi

Place
MsgBox "messagetext"
in Workbook_Open() event sub!

Post if you need help to instaal it!

Regards,
Stefi

„MR.WJCA†ezt írta:
 
M

MR.WJCA

Hi Stefi,

That is a nice tip.
But is something like this also possible without running a macro?
 
S

Stefi

Maybe you can attach a constantly displayed comment to a cell, say A1.
Stefi


„MR.WJCA†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make "File in use" message appear when 2 people open the a shared document in the same time 3
White space above heading inconsistently applied 1
Email notifications without opening application 1
Word 2013 DDE merge to Excel file 0
A couple questions BEFORE using Office 365 0
Popup box moving to new tab 5
Word and Excel opening for a few seconds then closing down 0
Problem with Upload Center on Office 2010 when using encrypted area on disk 0

Top