Sheet Within Sheet

  • Thread starter Thread starter acss
  • Start date Start date
A

acss

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.
 
yes of course
command button -> link to macro -> open / create / view sheets / workbooks
 
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.
 
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)
 
Back
Top