Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate sheet in another workbook by its code name
Is it possible to activate a sheet in workbook1 by a procedure written in
workbook2 by its code name?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate sheet in another workbook by its code name
With Workbooks("Some Other Book.xls")
.Worksheets(CStr(.VBProject.VBComponents("TheSheet CodeName").Properties("Name"))).Activate End With -- __________________________________ HTH Bob "AshMorK" wrote in message ... Is it possible to activate a sheet in workbook1 by a procedure written in workbook2 by its code name?? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate sheet in another workbook by its code name
Workbooks("Book2").Sheets("Sheet1").Activate
This will activate the workbook as well. "AshMorK" wrote: Is it possible to activate a sheet in workbook1 by a procedure written in workbook2 by its code name?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run Code on Activate Sheet | Excel Programming | |||
Activate code when sheet is deleted | Excel Programming | |||
Debug code in workbook open or activate events | Excel Programming | |||
WorkBook Open & Sheet Activate | Excel Programming | |||
Run a sheet's activate code when entering it's workbook | Excel Programming |