Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to open a Workbook and activate a specific sheet
If it is a Forms commandbutton you could use the Caller property
Workbooks.Open Filename:="C:\myDir\myFile.xls" Select Case Application.Caller Case "Button 1": Worksheets("Sheet1").Activate Case "Button 2": Worksheets("Sheet2").Activate End Select -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Kanan" wrote in message ... Hi, I have a situation... where I have to open workbook1 which has 10 sheets (sheet1...sheet10) from another workbook2 using different commandbuttons. The question is how do I open workbook1 and activate different sheets based on the command button. Is there anyway to pass the sheet name as an argument. or Are there any other methods? My workbook1 does have an auto_open macro. Kanan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
open workbook to specific sheet | Excel Worksheet Functions | |||
Using a Windows Shortcut to Open to Specific Sheet in Workbook | Excel Discussion (Misc queries) | |||
How do I open a workbook in a specific sheet | Excel Discussion (Misc queries) | |||
how to open a Workbook and activate a specific sheet | Excel Programming | |||
Write a Shortcut to Open Excel Workbook at a Specific Sheet | Excel Programming |