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
> >>
> >>
> >>
>
>
>