I recorded a macro for a worksheet and was trying to find out how to install a button on my sheet to run the macro. I can't seem to find a spot to do this. Its just a copy sheet macro but i would still like it to be run through a button on the sheet. Thanks.
Last edited by RMontani; 02-21-2011 at 12:59 AM.
Choose the Button control from the FORMS Toolbar. When you paste it onto the sheet the macro list dialog will appear. Select your macro.
Ben Van Johnson
Hi protonLeah. I feel a little stupid right now. I'm using excel 2010 and can't seem to locate the forms toolbar.
Maybe not so stupid. I found out where to look. Just needed to be pointed im the right direction. Thanks protonLeah
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks