How do I assign a macro to a button when the macro is in my personal workbook?

foolios · #3 07-27-2011, 02:41 PM

Quote:

Originally Posted by Kimberly

If the button is a shape you made, Right-click on the shape and choose Assign macro

Ok, when I tried it with a form button I made, it wouldn't work.
But when I made a active x button it immediately asked which macro to assign to it.

It now works!

I didn't get the assign macro context in the menu when I right-clicked the original button. But I did notice that under the View menu and submenu macros that the use relative references was an available option. How does thatwork?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word doc bug when closing from userform command button click macro	Joe Patrick	Word	1	07-05-2011 08:53 PM
Launch macro sub after hitting "create pdf" button in word	webharvest	Word VBA	1	06-29-2011 04:56 PM
macro to transfer data from one workbook to another workbook	virsojour	Excel Programming	5	02-01-2011 08:58 PM
Macro Button	B2W	Excel	2	06-18-2010 09:36 AM
Select a range in one one workbook while working in other workbook	Slow&Steady	Excel	1	02-21-2010 03:34 AM