| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for opening another sheet on button click
Hi,
I need to be able to open another worksheet when a button is clicked. What is the code for that. Thanks -- pmud |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code for opening another sheet on button click
Try
Workbooks.Open filename:="C:\whatever.xls" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "pmud" wrote in message ... Hi, I need to be able to open another worksheet when a button is clicked. What is the code for that. Thanks -- pmud |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code for opening another sheet on button click
Look in the VBA help for workbooks.Open
Workbooks.Open("C:\data\ron.xl*s") -- Regards Ron de Bruin http://www.rondebruin.nl "pmud" wrote in message ... Hi, I need to be able to open another worksheet when a button is clicked. What is the code for that. Thanks -- pmud |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code for opening another sheet on button click
Hi,
Its not another workbook, its a sheet within the same workbook.how to do that? Thanks -- pmud "Ron de Bruin" wrote: Look in the VBA help for workbooks.Open Workbooks.Open("C:\data\ron.xlÂ*s") -- Regards Ron de Bruin http://www.rondebruin.nl "pmud" wrote in message ... Hi, I need to be able to open another worksheet when a button is clicked. What is the code for that. Thanks -- pmud |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code for opening another sheet on button click
Sheets("yoursheet").select
-- Regards Ron de Bruin http://www.rondebruin.nl "pmud" wrote in message ... Hi, Its not another workbook, its a sheet within the same workbook.how to do that? Thanks -- pmud "Ron de Bruin" wrote: Look in the VBA help for workbooks.Open Workbooks.Open("C:\data\ron.xl*s") -- Regards Ron de Bruin http://www.rondebruin.nl "pmud" wrote in message ... Hi, I need to be able to open another worksheet when a button is clicked. What is the code for that. Thanks -- pmud |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code for opening another sheet on button click
Thanks Ron,
That worked. :) -- pmud "Ron de Bruin" wrote: Sheets("yoursheet").select -- Regards Ron de Bruin http://www.rondebruin.nl "pmud" wrote in message ... Hi, Its not another workbook, its a sheet within the same workbook.how to do that? Thanks -- pmud "Ron de Bruin" wrote: Look in the VBA help for workbooks.Open Workbooks.Open("C:\data\ron.xlÂ*s") -- Regards Ron de Bruin http://www.rondebruin.nl "pmud" wrote in message ... Hi, I need to be able to open another worksheet when a button is clicked. What is the code for that. Thanks -- pmud |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show different areas of sheet with a click radio button | Excel Discussion (Misc queries) | |||
| Not able to Click Button placed in the Work Sheet | Excel Worksheet Functions | |||
| right-click on a control button and view code does nothing | Excel Worksheet Functions | |||
| Code to tab from option button click | Excel Programming | |||
| Running command button click event code | Excel Programming | |||
Linear Mode
