Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VALIDATION IN EXCEL
Is there a way to set so a message displays at opening of a workbook/worksheet?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
How do I make a Validation List in Excel, using data on a second | Excel Discussion (Misc queries) | |||
Using Data Validation on an Excel web page | Excel Discussion (Misc queries) | |||
Data Validation Excel 97 | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |