Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet activate
Follwing is part of some code I'm using. The worksheet
activate is not invoked when it's workbook is open, but is invoked when it is manually activated. That is, when I activate another sheet and then activate sheet 2 again. What am I overlooking? Thanks! Private Sub App_WorkbookOpen(ByVal Wb As Workbook) Worksheets("sheet2").Activate End Sub Private Sub Worksheet_Activate() Dim MyRange, answer, mess, startR As Range, endR As Range, MRange As Range Set MyRange = Range("a7") MyRange.Select |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet activate
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet activate
From this link I understood that this event was triggered
by just opening the workbook. Not Correct? http://support.microsoft.com/default.aspx?scid=kb;en- us;213220&Product=vba -----Original Message----- Where are you calling App_WorkbookOpen from? --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to activate the scrolling within the worksheet? | Excel Discussion (Misc queries) | |||
Help! Activate worksheet from a listbox | Excel Worksheet Functions | |||
Worksheet.activate | Excel Discussion (Misc queries) | |||
Run Macro on Worksheet Activate | Excel Programming | |||
delayed worksheet.activate | Excel Programming |