Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Button Link
Can someone help me, I need to create a button to link to specific sheets in
a workbook. I don't know how to create the right code. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Button Link
What exactly do you mean by "link to specific sheets"? Buttons
are linked to macros, not sheets. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Benz" wrote in message ... Can someone help me, I need to create a button to link to specific sheets in a workbook. I don't know how to create the right code. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Button Link
Im new at this, I need to create a button that when clicked will bring up a
disignated sheet (at the bottom). "Chip Pearson" wrote: What exactly do you mean by "link to specific sheets"? Buttons are linked to macros, not sheets. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Benz" wrote in message ... Can someone help me, I need to create a button to link to specific sheets in a workbook. I don't know how to create the right code. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Button Link
Create a macro like
Sub ShowSheet() ActiveWorkbook.Worksheets("Sheet2").Select End Sub and attach that macro to your button. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Benz" wrote in message ... Im new at this, I need to create a button that when clicked will bring up a disignated sheet (at the bottom). "Chip Pearson" wrote: What exactly do you mean by "link to specific sheets"? Buttons are linked to macros, not sheets. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Benz" wrote in message ... Can someone help me, I need to create a button to link to specific sheets in a workbook. I don't know how to create the right code. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Button Link
Ok, I created a button with specific colors using visual basic and used the
code you gave. Now when I goto insert the button I can get it to link just fine, but it has the "default" button appearance. How do I change this? "Chip Pearson" wrote: Create a macro like Sub ShowSheet() ActiveWorkbook.Worksheets("Sheet2").Select End Sub and attach that macro to your button. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Benz" wrote in message ... Im new at this, I need to create a button that when clicked will bring up a disignated sheet (at the bottom). "Chip Pearson" wrote: What exactly do you mean by "link to specific sheets"? Buttons are linked to macros, not sheets. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Benz" wrote in message ... Can someone help me, I need to create a button to link to specific sheets in a workbook. I don't know how to create the right code. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Button Link
depends on which toolbar you used to produce the button.
Forms toolbar Control Toolbox Toolbar if the later, in design mode, right click on the Commandbutton and select properties. then set the properties you wish. Chips explanation would be more in line with one from the forms toolbar, but only limited customization are available for those - you can right click on it and select format control to see what is available. If you want your button to look like a flower, put a picture of a flower on your worksheet and right click on it, select assign macro and assign your macro to it (or use any autoshape). -- Regards, Tom Ogilvy "Benz" wrote: Ok, I created a button with specific colors using visual basic and used the code you gave. Now when I goto insert the button I can get it to link just fine, but it has the "default" button appearance. How do I change this? "Chip Pearson" wrote: Create a macro like Sub ShowSheet() ActiveWorkbook.Worksheets("Sheet2").Select End Sub and attach that macro to your button. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Benz" wrote in message ... Im new at this, I need to create a button that when clicked will bring up a disignated sheet (at the bottom). "Chip Pearson" wrote: What exactly do you mean by "link to specific sheets"? Buttons are linked to macros, not sheets. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Benz" wrote in message ... Can someone help me, I need to create a button to link to specific sheets in a workbook. I don't know how to create the right code. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link button name to a cell | Excel Discussion (Misc queries) | |||
how to link a macro to a button on the excel sheet | Excel Discussion (Misc queries) | |||
How do I link a macro to a customized icon button? | Excel Programming | |||
button link | Excel Discussion (Misc queries) | |||
Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming |