problem assigning macro to button

kristie · Apr 9th, 2002, 06:08 AM

I have currently got three buttons in operation on my spreadshett-each with their macro working perfectly. however i am having difficulty assigning a macro to a new button it keeps giving me an error message: Formula is too complex to be assigned to object.
if anyone has any words of advice for me that would be great!
thank you in advance.

Anne Troy · Apr 9th, 2002, 06:43 AM

What is the name of the macro that you're trying to assign to the button?

kristie · Apr 9th, 2002, 09:56 AM

its called:
button19_click

Apr 9th, 2002, 06:43 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	What is the name of the macro that you're trying to assign to the button? __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 06:08 AM	#1
kristie New Member Join Date: Apr 2002 Location: London Posts: 2	I have currently got three buttons in operation on my spreadshett-each with their macro working perfectly. however i am having difficulty assigning a macro to a new button it keeps giving me an error message: Formula is too complex to be assigned to object. if anyone has any words of advice for me that would be great! thank you in advance.

Apr 9th, 2002, 09:56 AM	#3
kristie New Member Join Date: Apr 2002 Location: London Posts: 2	its called: button19_click