Just a button
 

Ok, Got a Stupid question for ya.
I have a button I want to open a sheet, not a user form.
The sheets name is “Price Page”.
I can’t figure it out.
Told ya it was stupid.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Just a button
 

How about

Sub GoThere()
Application.Goto Sheets("Price Page").Range("A1"), True
End Sub

which assumes that the 'Price Range' sheet is in the active workbook.

--
Regards,

Juan Pablo González

"wssparky" wrote in message
...

Ok, Got a Stupid question for ya.
I have a button I want to open a sheet, not a user form.
The sheets name is "Price Page".
I can't figure it out.
Told ya it was stupid.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Just a button
 

sub Button1_Click()
worksheets("Price Page").Activate
End sub

--
Regards,
Tom Ogilvy

wssparky wrote in message
...

Ok, Got a Stupid question for ya.
I have a button I want to open a sheet, not a user form.
The sheets name is "Price Page".
I can't figure it out.
Told ya it was stupid.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Just a button
 

Thanks !!
I was putting
..Show
It just the simple things ....

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!