Macro buttons ...help please

  • Thread starter Thread starter ttd
  • Start date Start date
T

ttd

Office XP Pro
Win98se

I have a worksheet from 1994 with many macros involved...the 1 below
is an example :

' BLACK Macro
' Macro recorded 20/04/95 by HENRY
'
'
Sub BLACK()
Range("f3").Select
ActiveCell.FormulaR1C1 = "Black"
Range("f4").Select
End Sub

What I need help with is to have the macro button appear to move when
clicked with mouse cursor ..like menu icons do currently.
Is it possible please....if so how may I build it into the above VBA
macro.
I have very limited knowledge of macro but willing to learn the
basics.
If I right click on the existing macro cell (button), I have option to
"assign" a macro then edit it.
Also if the macro cell (buuton) is highlighted and I go to Tools/Macro
then I have option to "step into" .

TIA
 
Why not create a new button and point it to the old Macro
then delete the old button?

Charlie O'Neill
 
Back
Top