Thread: Code for opening another sheet on button click
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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





Reply With QuoteReply With Quote