Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Qn: Worksheet Open???
Hello Everyone,
Is there a way initialize a worksheet when it is opened. I know I can do it with a workbook when it is opened, but I wanted to put a subroutine that will check a cell to see if it has data in it, if NOT, then to msgbox "Setup Not Complete, would you like to complete your setup now?? Can you put a initialize in a worksheet??? Thanks.. mv |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Open???
Each worksheet has an activate event. It is possible you could use that.
The sheet that is visible when the workbook is opened will not fire its activate event, so you would probably want to have another sheet active when opening. You could do this in the Workbook_Open event. http://www.cpearson.com/excel/events.htm Chip Pearson's page on events. -- Regards, Tom Ogilvy "Michael Vaughan" wrote in message ... Hello Everyone, Is there a way initialize a worksheet when it is opened. I know I can do it with a workbook when it is opened, but I wanted to put a subroutine that will check a cell to see if it has data in it, if NOT, then to msgbox "Setup Not Complete, would you like to complete your setup now?? Can you put a initialize in a worksheet??? Thanks.. mv |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007, Automatically open new worksheet on open. | Excel Discussion (Misc queries) | |||
My desktop worksheet shortcut will not open the Excel Worksheet | Excel Discussion (Misc queries) | |||
How do I get a blank worksheet to open up when I open Excel? | Setting up and Configuration of Excel | |||
'Save current worksheet'; 'Open next worksheet' - two command buttons | Excel Discussion (Misc queries) | |||
How do I get my personal macro worksheet to open whenever I open . | Excel Discussion (Misc queries) |