Just a button

  • Thread starter Thread starter wssparky
  • Start date Start date
W

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top