Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ginger
 
Posts: n/a
Default VALIDATION IN EXCEL

Is there a way to set so a message displays at opening of a workbook/worksheet?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default VALIDATION IN EXCEL

Create a form on the VBA and use the command


Option Explicit

Private Sub Workbook_Open()

NomeDoForm.Show

End Sub

Regards


"Ginger" escreveu:

Is there a way to set so a message displays at opening of a workbook/worksheet?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Otto Moehrbach
 
Posts: n/a
Default VALIDATION IN EXCEL

Ginger
There are several ways to display a message at opening. Marcelo gave
you one. Another is to display a message box (MsgBox). The message box can
be simply informative and have an OK button, or it can ask a question (and
have Yes and No buttons) if appropriate, depending on your purpose. Post
back and tell us what you want to do. HTH Otto
"Ginger" wrote in message
...
Is there a way to set so a message displays at opening of a
workbook/worksheet?



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ginger
 
Posts: n/a
Default VALIDATION IN EXCEL

Thank you for your responses, what I would like to have is a message box
which pops-up when you open a workbook/worksheet. I would like this to only
pop-up every two weeks, the purpose is to remind employees of a specific event

"Otto Moehrbach" wrote:

Ginger
There are several ways to display a message at opening. Marcelo gave
you one. Another is to display a message box (MsgBox). The message box can
be simply informative and have an OK button, or it can ask a question (and
have Yes and No buttons) if appropriate, depending on your purpose. Post
back and tell us what you want to do. HTH Otto
"Ginger" wrote in message
...
Is there a way to set so a message displays at opening of a
workbook/worksheet?




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
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 12 April 4th 23 02:12 PM
How do I make a Validation List in Excel, using data on a second Driver Excel Discussion (Misc queries) 2 February 23rd 06 01:30 PM
Using Data Validation on an Excel web page Chikita Excel Discussion (Misc queries) 0 June 7th 05 07:44 PM
Data Validation Excel 97 Boab1965 Excel Discussion (Misc queries) 3 June 7th 05 01:34 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM


All times are GMT +1. The time now is 12:49 AM.

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"