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

Try

Workbooks.Open filename:="C:\whatever.xls"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"pmud" <pmud@discussions.microsoft.com> wrote in message
news:DA76355A-1CFF-4CBB-8E60-C5975CFD79C2@microsoft.com...
> Hi,
>
> I need to be able to open another worksheet when a button is
> clicked.
>
> What is the code for that.
>
> Thanks
> --
> pmud

Look in the VBA help for workbooks.Open

Workbooks.Open("C:\data\ron.xl*s")



--
Regards Ron de Bruin
http://www.rondebruin.nl



"pmud" <pmud@discussions.microsoft.com> wrote in message news:DA76355A-1CFF-4CBB-8E60-C5975CFD79C2@microsoft.com...
> Hi,
>
> I need to be able to open another worksheet when a button is clicked.
>
> What is the code for that.
>
> Thanks
> --
> pmud

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" <pmud@discussions.microsoft.com> wrote in message news:DA76355A-1CFF-4CBB-8E60-C5975CFD79C2@microsoft.com...
> > Hi,
> >
> > I need to be able to open another worksheet when a button is clicked.
> >
> > What is the code for that.
> >
> > Thanks
> > --
> > pmud
>
>
>

Sheets("yoursheet").select

--
Regards Ron de Bruin
http://www.rondebruin.nl



"pmud" <pmud@discussions.microsoft.com> wrote in message news:0278F388-638A-4E77-9DF5-D79D0C42DD64@microsoft.com...
> 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" <pmud@discussions.microsoft.com> wrote in message news:DA76355A-1CFF-4CBB-8E60-C5975CFD79C2@microsoft.com...
>> > Hi,
>> >
>> > I need to be able to open another worksheet when a button is clicked.
>> >
>> > What is the code for that.
>> >
>> > Thanks
>> > --
>> > pmud
>>
>>
>>

Thanks Ron,

That worked.
--
pmud


"Ron de Bruin" wrote:

> Sheets("yoursheet").select
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "pmud" <pmud@discussions.microsoft.com> wrote in message news:0278F388-638A-4E77-9DF5-D79D0C42DD64@microsoft.com...
> > 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" <pmud@discussions.microsoft.com> wrote in message news:DA76355A-1CFF-4CBB-8E60-C5975CFD79C2@microsoft.com...
> >> > Hi,
> >> >
> >> > I need to be able to open another worksheet when a button is clicked.
> >> >
> >> > What is the code for that.
> >> >
> >> > Thanks
> >> > --
> >> > pmud
> >>
> >>
> >>
>
>
>