Just a button

[wssparky]

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!

 

[Juan Pablo González]

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.

 

[Tom Ogilvy]

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

 

[wssparky]

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!