Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Within Sheet
New to excell and i would like to know if a command botton can be placed on a
sheet which the end user can press then it will open another sheet? Any assistance would be greatly appreciated in directions given. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Within Sheet
yes of course
command button - link to macro - open / create / view sheets / workbooks "acss" wrote: New to excell and i would like to know if a command botton can be placed on a sheet which the end user can press then it will open another sheet? Any assistance would be greatly appreciated in directions given. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Within Sheet
Thanks larzize but as stated i am new at this so if you could be so kind to
provide more details since i do not understand your response. "larzize" wrote: yes of course command button - link to macro - open / create / view sheets / workbooks "acss" wrote: New to excell and i would like to know if a command botton can be placed on a sheet which the end user can press then it will open another sheet? Any assistance would be greatly appreciated in directions given. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Within Sheet
By "open another sheet", I assume you mean to go to a different sheet (tab)
within the same workbook, not to a sheet in a different workbook. Open the VBA Editor (ALT F11) and insert a Module (from the Insert menu). In that module, use the following code. Change the name of the worksheet to the name of the sheet to which you want to send the user. Sub GoToSheet() On Error Resume Next ThisWorkbook.Worksheets("Sheet1").Select '<<< CHANGE SHEET NAME End Sub Now, back in Excel, go to the View menu and choose ToolBars and there select Forms. Drag a command button from the Forms toolbar on to the worksheet. Change the text as desired. Right-click the command button and select 'Assign Macro'. There, choose 'GoToSheet'. Now, when the user clicks the button, the 'GoToSheet' procedure will be executed and that procedure will take the user to the worksheet specified in the code. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "acss" wrote in message ... New to excell and i would like to know if a command botton can be placed on a sheet which the end user can press then it will open another sheet? Any assistance would be greatly appreciated in directions given. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |