button in a cell to activate a macro
nevermind, i was able to delete it.
"Ann" wrote:
great, i was trying to do the same thing, another poster helped me there. if
i accidently created one, how do i delete it?
"Dave" wrote:
Hi,
One way:
View Toolbars Forms
Select the button (hover mouse over each to find "button")
Click on the sheet where you want the button to be.
The Assign Macro window will open.
Choose the macro you want the button to run.
Format the button as desired (Change size, text, etc)
Click away from the button to exit edit mode.
Click button to run macro.
You can also do the same with the shapes from the drawing toolbar
Regards - Dave.
|