Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Command Button
Need help creating a command button within a workbook (Book1) that will open
a different worksheet (Tab5) within the same workbook. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Command Button
Place ANY piece of ClipArt on the worksheet. If you like buttons, make a
button using the rectangle from AutoShapes. Right-click the Object and pick Assign Hyperlink. Make the hyperlink to a place on Tab5 -- Gary''s Student - gsnu200830 "Priss" wrote: Need help creating a command button within a workbook (Book1) that will open a different worksheet (Tab5) within the same workbook. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Command Button
Okay, I am working with Office 2007. I choose a command button, right click
and didn't see what you mentioned. I even tryed the ActiveX control as well. I think I am just lost. "Gary''s Student" wrote: Place ANY piece of ClipArt on the worksheet. If you like buttons, make a button using the rectangle from AutoShapes. Right-click the Object and pick Assign Hyperlink. Make the hyperlink to a place on Tab5 -- Gary''s Student - gsnu200830 "Priss" wrote: Need help creating a command button within a workbook (Book1) that will open a different worksheet (Tab5) within the same workbook. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Command Button
O.K. Put this macro in a standard module:
Sub Macro3() Application.Goto Reference:="Tab5!R[-8]C[-11]" End Sub If you have put a Forms button on the sheets, then right-click the button and use Assign Macro If you have put a Controls button the sheet, first click on Design mode, then right-click the button and select View Code. Then insert the line: Call Macro3 in the sub that appears -- Gary''s Student - gsnu200830 "Priss" wrote: Okay, I am working with Office 2007. I choose a command button, right click and didn't see what you mentioned. I even tryed the ActiveX control as well. I think I am just lost. "Gary''s Student" wrote: Place ANY piece of ClipArt on the worksheet. If you like buttons, make a button using the rectangle from AutoShapes. Right-click the Object and pick Assign Hyperlink. Make the hyperlink to a place on Tab5 -- Gary''s Student - gsnu200830 "Priss" wrote: Need help creating a command button within a workbook (Book1) that will open a different worksheet (Tab5) within the same workbook. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Command Button
Okay, I know it's user error and I am not that familiar. It may have
something to do with the way I am explaining too. But my workbook has (7) worksheets - tab 1-7. One of those worksheets have names on it. When the individual click there command button, I want it to go to that particular worksheet which is for them ONLY. Not sure if this helped. "Gary''s Student" wrote: O.K. Put this macro in a standard module: Sub Macro3() Application.Goto Reference:="Tab5!R[-8]C[-11]" End Sub If you have put a Forms button on the sheets, then right-click the button and use Assign Macro If you have put a Controls button the sheet, first click on Design mode, then right-click the button and select View Code. Then insert the line: Call Macro3 in the sub that appears -- Gary''s Student - gsnu200830 "Priss" wrote: Okay, I am working with Office 2007. I choose a command button, right click and didn't see what you mentioned. I even tryed the ActiveX control as well. I think I am just lost. "Gary''s Student" wrote: Place ANY piece of ClipArt on the worksheet. If you like buttons, make a button using the rectangle from AutoShapes. Right-click the Object and pick Assign Hyperlink. Make the hyperlink to a place on Tab5 -- Gary''s Student - gsnu200830 "Priss" wrote: Need help creating a command button within a workbook (Book1) that will open a different worksheet (Tab5) within the same workbook. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Command Button
What is the name of the worksheet (tabname) that you want to jump to??
Is it Sheet5 or Tab5 ?? I am refering to the name on the worksheet tab at the bottom of the Excel window. -- Gary''s Student - gsnu200830 "Priss" wrote: Okay, I know it's user error and I am not that familiar. It may have something to do with the way I am explaining too. But my workbook has (7) worksheets - tab 1-7. One of those worksheets have names on it. When the individual click there command button, I want it to go to that particular worksheet which is for them ONLY. Not sure if this helped. "Gary''s Student" wrote: O.K. Put this macro in a standard module: Sub Macro3() Application.Goto Reference:="Tab5!R[-8]C[-11]" End Sub If you have put a Forms button on the sheets, then right-click the button and use Assign Macro If you have put a Controls button the sheet, first click on Design mode, then right-click the button and select View Code. Then insert the line: Call Macro3 in the sub that appears -- Gary''s Student - gsnu200830 "Priss" wrote: Okay, I am working with Office 2007. I choose a command button, right click and didn't see what you mentioned. I even tryed the ActiveX control as well. I think I am just lost. "Gary''s Student" wrote: Place ANY piece of ClipArt on the worksheet. If you like buttons, make a button using the rectangle from AutoShapes. Right-click the Object and pick Assign Hyperlink. Make the hyperlink to a place on Tab5 -- Gary''s Student - gsnu200830 "Priss" wrote: Need help creating a command button within a workbook (Book1) that will open a different worksheet (Tab5) within the same workbook. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Command Button
I want to jump Tab2 based on command button 1 and then Tab3 based on command
button 2 . There name is on the command button. "Gary''s Student" wrote: What is the name of the worksheet (tabname) that you want to jump to?? Is it Sheet5 or Tab5 ?? I am refering to the name on the worksheet tab at the bottom of the Excel window. -- Gary''s Student - gsnu200830 "Priss" wrote: Okay, I know it's user error and I am not that familiar. It may have something to do with the way I am explaining too. But my workbook has (7) worksheets - tab 1-7. One of those worksheets have names on it. When the individual click there command button, I want it to go to that particular worksheet which is for them ONLY. Not sure if this helped. "Gary''s Student" wrote: O.K. Put this macro in a standard module: Sub Macro3() Application.Goto Reference:="Tab5!R[-8]C[-11]" End Sub If you have put a Forms button on the sheets, then right-click the button and use Assign Macro If you have put a Controls button the sheet, first click on Design mode, then right-click the button and select View Code. Then insert the line: Call Macro3 in the sub that appears -- Gary''s Student - gsnu200830 "Priss" wrote: Okay, I am working with Office 2007. I choose a command button, right click and didn't see what you mentioned. I even tryed the ActiveX control as well. I think I am just lost. "Gary''s Student" wrote: Place ANY piece of ClipArt on the worksheet. If you like buttons, make a button using the rectangle from AutoShapes. Right-click the Object and pick Assign Hyperlink. Make the hyperlink to a place on Tab5 -- Gary''s Student - gsnu200830 "Priss" wrote: Need help creating a command button within a workbook (Book1) that will open a different worksheet (Tab5) within the same workbook. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Command Button
Assuming the names on the tabs are Tab2, Tab3, etc., then use this macro for
Command Button 1... Sub GoToTab2() Sheets("Tab2").Activate End Sub Use this macro for Command Button 2... Sub GoToTab3() Sheets("Tab3").Activate End Sub The name of the macros is unimportant; how to continue this process should be apparent. -- Rick (MVP - Excel) "Priss" wrote in message ... I want to jump Tab2 based on command button 1 and then Tab3 based on command button 2 . There name is on the command button. "Gary''s Student" wrote: What is the name of the worksheet (tabname) that you want to jump to?? Is it Sheet5 or Tab5 ?? I am refering to the name on the worksheet tab at the bottom of the Excel window. -- Gary''s Student - gsnu200830 "Priss" wrote: Okay, I know it's user error and I am not that familiar. It may have something to do with the way I am explaining too. But my workbook has (7) worksheets - tab 1-7. One of those worksheets have names on it. When the individual click there command button, I want it to go to that particular worksheet which is for them ONLY. Not sure if this helped. "Gary''s Student" wrote: O.K. Put this macro in a standard module: Sub Macro3() Application.Goto Reference:="Tab5!R[-8]C[-11]" End Sub If you have put a Forms button on the sheets, then right-click the button and use Assign Macro If you have put a Controls button the sheet, first click on Design mode, then right-click the button and select View Code. Then insert the line: Call Macro3 in the sub that appears -- Gary''s Student - gsnu200830 "Priss" wrote: Okay, I am working with Office 2007. I choose a command button, right click and didn't see what you mentioned. I even tryed the ActiveX control as well. I think I am just lost. "Gary''s Student" wrote: Place ANY piece of ClipArt on the worksheet. If you like buttons, make a button using the rectangle from AutoShapes. Right-click the Object and pick Assign Hyperlink. Make the hyperlink to a place on Tab5 -- Gary''s Student - gsnu200830 "Priss" wrote: Need help creating a command button within a workbook (Book1) that will open a different worksheet (Tab5) within the same workbook. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Command Button
Thanks for direction...
Here is what I ended up doing - Private Sub CommandButton1_Click() Sheets("Tab3").Select End Sub Now that I am on that sheet, I want to save it and return back to the main "name" sheet. This is what I have so far. But it doesn't take me back to the "name". Private Sub CommandButton1_Click() Sheet5.Activate OKtoSave = True ThisWorkbook.Save End Sub "Rick Rothstein" wrote: Assuming the names on the tabs are Tab2, Tab3, etc., then use this macro for Command Button 1... Sub GoToTab2() Sheets("Tab2").Activate End Sub Use this macro for Command Button 2... Sub GoToTab3() Sheets("Tab3").Activate End Sub The name of the macros is unimportant; how to continue this process should be apparent. -- Rick (MVP - Excel) "Priss" wrote in message ... I want to jump Tab2 based on command button 1 and then Tab3 based on command button 2 . There name is on the command button. "Gary''s Student" wrote: What is the name of the worksheet (tabname) that you want to jump to?? Is it Sheet5 or Tab5 ?? I am refering to the name on the worksheet tab at the bottom of the Excel window. -- Gary''s Student - gsnu200830 "Priss" wrote: Okay, I know it's user error and I am not that familiar. It may have something to do with the way I am explaining too. But my workbook has (7) worksheets - tab 1-7. One of those worksheets have names on it. When the individual click there command button, I want it to go to that particular worksheet which is for them ONLY. Not sure if this helped. "Gary''s Student" wrote: O.K. Put this macro in a standard module: Sub Macro3() Application.Goto Reference:="Tab5!R[-8]C[-11]" End Sub If you have put a Forms button on the sheets, then right-click the button and use Assign Macro If you have put a Controls button the sheet, first click on Design mode, then right-click the button and select View Code. Then insert the line: Call Macro3 in the sub that appears -- Gary''s Student - gsnu200830 "Priss" wrote: Okay, I am working with Office 2007. I choose a command button, right click and didn't see what you mentioned. I even tryed the ActiveX control as well. I think I am just lost. "Gary''s Student" wrote: Place ANY piece of ClipArt on the worksheet. If you like buttons, make a button using the rectangle from AutoShapes. Right-click the Object and pick Assign Hyperlink. Make the hyperlink to a place on Tab5 -- Gary''s Student - gsnu200830 "Priss" wrote: Need help creating a command button within a workbook (Book1) that will open a different worksheet (Tab5) within the same workbook. |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Command Button
Let's get the obvious question out of the way... is the "main 'name'" sheet
named "Sheet5"? -- Rick (MVP - Excel) "Priss" wrote in message ... Thanks for direction... Here is what I ended up doing - Private Sub CommandButton1_Click() Sheets("Tab3").Select End Sub Now that I am on that sheet, I want to save it and return back to the main "name" sheet. This is what I have so far. But it doesn't take me back to the "name". Private Sub CommandButton1_Click() Sheet5.Activate OKtoSave = True ThisWorkbook.Save End Sub "Rick Rothstein" wrote: Assuming the names on the tabs are Tab2, Tab3, etc., then use this macro for Command Button 1... Sub GoToTab2() Sheets("Tab2").Activate End Sub Use this macro for Command Button 2... Sub GoToTab3() Sheets("Tab3").Activate End Sub The name of the macros is unimportant; how to continue this process should be apparent. -- Rick (MVP - Excel) "Priss" wrote in message ... I want to jump Tab2 based on command button 1 and then Tab3 based on command button 2 . There name is on the command button. "Gary''s Student" wrote: What is the name of the worksheet (tabname) that you want to jump to?? Is it Sheet5 or Tab5 ?? I am refering to the name on the worksheet tab at the bottom of the Excel window. -- Gary''s Student - gsnu200830 "Priss" wrote: Okay, I know it's user error and I am not that familiar. It may have something to do with the way I am explaining too. But my workbook has (7) worksheets - tab 1-7. One of those worksheets have names on it. When the individual click there command button, I want it to go to that particular worksheet which is for them ONLY. Not sure if this helped. "Gary''s Student" wrote: O.K. Put this macro in a standard module: Sub Macro3() Application.Goto Reference:="Tab5!R[-8]C[-11]" End Sub If you have put a Forms button on the sheets, then right-click the button and use Assign Macro If you have put a Controls button the sheet, first click on Design mode, then right-click the button and select View Code. Then insert the line: Call Macro3 in the sub that appears -- Gary''s Student - gsnu200830 "Priss" wrote: Okay, I am working with Office 2007. I choose a command button, right click and didn't see what you mentioned. I even tryed the ActiveX control as well. I think I am just lost. "Gary''s Student" wrote: Place ANY piece of ClipArt on the worksheet. If you like buttons, make a button using the rectangle from AutoShapes. Right-click the Object and pick Assign Hyperlink. Make the hyperlink to a place on Tab5 -- Gary''s Student - gsnu200830 "Priss" wrote: Need help creating a command button within a workbook (Book1) that will open a different worksheet (Tab5) within the same workbook. |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Command Button
The "main sheet" is called BP Sign-on. The names reside on this sheet. Once
they click the button with their name, is goes to their sheet (TAB2). They update, click command button to save - but I want it to go back to the BP Sign-on for the next person when they open it. "Rick Rothstein" wrote: Let's get the obvious question out of the way... is the "main 'name'" sheet named "Sheet5"? -- Rick (MVP - Excel) "Priss" wrote in message ... Thanks for direction... Here is what I ended up doing - Private Sub CommandButton1_Click() Sheets("Tab3").Select End Sub Now that I am on that sheet, I want to save it and return back to the main "name" sheet. This is what I have so far. But it doesn't take me back to the "name". Private Sub CommandButton1_Click() Sheet5.Activate OKtoSave = True ThisWorkbook.Save End Sub "Rick Rothstein" wrote: Assuming the names on the tabs are Tab2, Tab3, etc., then use this macro for Command Button 1... Sub GoToTab2() Sheets("Tab2").Activate End Sub Use this macro for Command Button 2... Sub GoToTab3() Sheets("Tab3").Activate End Sub The name of the macros is unimportant; how to continue this process should be apparent. -- Rick (MVP - Excel) "Priss" wrote in message ... I want to jump Tab2 based on command button 1 and then Tab3 based on command button 2 . There name is on the command button. "Gary''s Student" wrote: What is the name of the worksheet (tabname) that you want to jump to?? Is it Sheet5 or Tab5 ?? I am refering to the name on the worksheet tab at the bottom of the Excel window. -- Gary''s Student - gsnu200830 "Priss" wrote: Okay, I know it's user error and I am not that familiar. It may have something to do with the way I am explaining too. But my workbook has (7) worksheets - tab 1-7. One of those worksheets have names on it. When the individual click there command button, I want it to go to that particular worksheet which is for them ONLY. Not sure if this helped. "Gary''s Student" wrote: O.K. Put this macro in a standard module: Sub Macro3() Application.Goto Reference:="Tab5!R[-8]C[-11]" End Sub If you have put a Forms button on the sheets, then right-click the button and use Assign Macro If you have put a Controls button the sheet, first click on Design mode, then right-click the button and select View Code. Then insert the line: Call Macro3 in the sub that appears -- Gary''s Student - gsnu200830 "Priss" wrote: Okay, I am working with Office 2007. I choose a command button, right click and didn't see what you mentioned. I even tryed the ActiveX control as well. I think I am just lost. "Gary''s Student" wrote: Place ANY piece of ClipArt on the worksheet. If you like buttons, make a button using the rectangle from AutoShapes. Right-click the Object and pick Assign Hyperlink. Make the hyperlink to a place on Tab5 -- Gary''s Student - gsnu200830 "Priss" wrote: Need help creating a command button within a workbook (Book1) that will open a different worksheet (Tab5) within the same workbook. |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Command Button
Then add this line after the Save line...
Sheets("BP Sign-on").Activate -- Rick (MVP - Excel) "Priss" wrote in message ... The "main sheet" is called BP Sign-on. The names reside on this sheet. Once they click the button with their name, is goes to their sheet (TAB2). They update, click command button to save - but I want it to go back to the BP Sign-on for the next person when they open it. "Rick Rothstein" wrote: Let's get the obvious question out of the way... is the "main 'name'" sheet named "Sheet5"? -- Rick (MVP - Excel) "Priss" wrote in message ... Thanks for direction... Here is what I ended up doing - Private Sub CommandButton1_Click() Sheets("Tab3").Select End Sub Now that I am on that sheet, I want to save it and return back to the main "name" sheet. This is what I have so far. But it doesn't take me back to the "name". Private Sub CommandButton1_Click() Sheet5.Activate OKtoSave = True ThisWorkbook.Save End Sub "Rick Rothstein" wrote: Assuming the names on the tabs are Tab2, Tab3, etc., then use this macro for Command Button 1... Sub GoToTab2() Sheets("Tab2").Activate End Sub Use this macro for Command Button 2... Sub GoToTab3() Sheets("Tab3").Activate End Sub The name of the macros is unimportant; how to continue this process should be apparent. -- Rick (MVP - Excel) "Priss" wrote in message ... I want to jump Tab2 based on command button 1 and then Tab3 based on command button 2 . There name is on the command button. "Gary''s Student" wrote: What is the name of the worksheet (tabname) that you want to jump to?? Is it Sheet5 or Tab5 ?? I am refering to the name on the worksheet tab at the bottom of the Excel window. -- Gary''s Student - gsnu200830 "Priss" wrote: Okay, I know it's user error and I am not that familiar. It may have something to do with the way I am explaining too. But my workbook has (7) worksheets - tab 1-7. One of those worksheets have names on it. When the individual click there command button, I want it to go to that particular worksheet which is for them ONLY. Not sure if this helped. "Gary''s Student" wrote: O.K. Put this macro in a standard module: Sub Macro3() Application.Goto Reference:="Tab5!R[-8]C[-11]" End Sub If you have put a Forms button on the sheets, then right-click the button and use Assign Macro If you have put a Controls button the sheet, first click on Design mode, then right-click the button and select View Code. Then insert the line: Call Macro3 in the sub that appears -- Gary''s Student - gsnu200830 "Priss" wrote: Okay, I am working with Office 2007. I choose a command button, right click and didn't see what you mentioned. I even tryed the ActiveX control as well. I think I am just lost. "Gary''s Student" wrote: Place ANY piece of ClipArt on the worksheet. If you like buttons, make a button using the rectangle from AutoShapes. Right-click the Object and pick Assign Hyperlink. Make the hyperlink to a place on Tab5 -- Gary''s Student - gsnu200830 "Priss" wrote: Need help creating a command button within a workbook (Book1) that will open a different worksheet (Tab5) within the same workbook. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
command button add another command | Excel Discussion (Misc queries) | |||
VBA Command Button | Excel Discussion (Misc queries) | |||
command button | Excel Discussion (Misc queries) | |||
command button | Excel Discussion (Misc queries) | |||
Using a command button to add | Excel Discussion (Misc queries) |