Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro button on one sheet only
Hi,
when I create a button and place it on the toolbar and then assign a macro to it, is it possible to have that button display on the toolbar in the one sheet it was intended for only and no other sheet? Thanks, Noel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro button on one sheet only
Wouldn't it be easier to insert a row at the top of your sheet, put the
macro button on this row and then freeze the pane? "Nleric" wrote in message ... Hi, when I create a button and place it on the toolbar and then assign a macro to it, is it possible to have that button display on the toolbar in the one sheet it was intended for only and no other sheet? Thanks, Noel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro button on one sheet only
Why not just put the button on the sheet??
-- Don Guillett SalesAid Software "Nleric" wrote in message ... Hi, when I create a button and place it on the toolbar and then assign a macro to it, is it possible to have that button display on the toolbar in the one sheet it was intended for only and no other sheet? Thanks, Noel |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro button on one sheet only
Alternatively you could use something like the following:-
First Create a toolbar called MyMacros, then assign your button to that toolbar, Then lets say that the sheet you want the toolbar to display when activated is called mymacros_sheet. Private Sub Workbook_SheetActivate(ByVal Sh As Object) If Sh.name = "MyMacros_Sheet" Then Application.CommandBars("MyMacros").Visible = True Else Application.CommandBars("MyMacros").Visible = False End If End Sub HTH Andi "Don Guillett" wrote in message ... Why not just put the button on the sheet?? -- Don Guillett SalesAid Software "Nleric" wrote in message ... Hi, when I create a button and place it on the toolbar and then assign a macro to it, is it possible to have that button display on the toolbar in the one sheet it was intended for only and no other sheet? Thanks, Noel |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro button on one sheet only
Thanks for the replies, I am new to this and was having a Homer Simpson
moment :-))) Noel "Andibevan" wrote: Alternatively you could use something like the following:- First Create a toolbar called MyMacros, then assign your button to that toolbar, Then lets say that the sheet you want the toolbar to display when activated is called mymacros_sheet. Private Sub Workbook_SheetActivate(ByVal Sh As Object) If Sh.name = "MyMacros_Sheet" Then Application.CommandBars("MyMacros").Visible = True Else Application.CommandBars("MyMacros").Visible = False End If End Sub HTH Andi "Don Guillett" wrote in message ... Why not just put the button on the sheet?? -- Don Guillett SalesAid Software "Nleric" wrote in message ... Hi, when I create a button and place it on the toolbar and then assign a macro to it, is it possible to have that button display on the toolbar in the one sheet it was intended for only and no other sheet? Thanks, Noel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Button in a work sheet | Excel Discussion (Misc queries) | |||
Move Macro Button on Sheet to a toolbar | Excel Discussion (Misc queries) | |||
use macro button to run macro in protected sheet | Excel Discussion (Misc queries) | |||
How do I create a macro button and place anywhere on my sheet? | Excel Discussion (Misc queries) | |||
Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming |