| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Undo button and redo button quit | Excel Discussion (Misc queries) | |||
| Inserting a Graphic on a Button when the Button is Assigned to a M | Excel Discussion (Misc queries) | |||
| insert row above button (retrieve position of button) | Excel Discussion (Misc queries) | |||
| How can I assign a symbol to a button (like the $ button) | Excel Discussion (Misc queries) | |||
| How do I lock a radio button group if a N/A button is selected | Excel Discussion (Misc queries) | |||
Hybrid Mode
