I need to create a button to allow me to click on this button and run a
macro. I am almost positive I know how to assign the macro, I just can't
remember how to create the button in the first place. Can someone help?
I need to create a button to allow me to click on this button and run a
macro. I am almost positive I know how to assign the macro, I just can't
remember how to create the button in the first place. Can someone help?
Tools>Customize Tools Tab and check the Forms box. Now, from that new
toolbar, click the button icon, and then draw it on the worksheet. It will
prompt for a macro to assign.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Brian" <[email protected]> wrote in message
news:[email protected]...
> I need to create a button to allow me to click on this button and run a
> macro. I am almost positive I know how to assign the macro, I just can't
> remember how to create the button in the first place. Can someone help?
You can also assign the macro to any shape from the Drawing Toolbar.
(View...Toolbars...Drawing). Once you create the shape on your sheet,
you right click it to assign your macro.
OnceTall
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks