"Formula is too complex to be assigned to object" ?

  • Thread starter Thread starter Markus Scheible
  • Start date Start date
M

Markus Scheible

Hi newsgroup,

"Formula is too complex to be assigned to object" ?

does someone know why I get this error when I want to
assign a Macro to a button? The thing is that I had much
longer Macros assigned to other buttons without any
problems.... btw: the error is also shown if I cut most of
the Macro and retry to assign it... very diffusing.

Thanks a lot i.a. and best regards

Markus
 
Same problem here. I had a corrupted Excel-file with lots of VBA.
created a new Excel-file, copied the sheets en created new modules i
which I pasted the old code. I now have to reassign the macros to th
buttons but I seem not to be able to assign any macro anymore withou
the error "Formula too complex to be assigned to object"

Anyone
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re: Reference must be to a macro sheet? 0
Buttons re-assigned themselves to the right macro name but in Book 1
Assign Macro to Ribbon Button 6
View what macro is assigned to a tool bar button 1
Assigning macro buttons to macro code in another file 2
Code to assign a macro to hundreds of option buttons at once 1
Can't change macro assigned to drawing object 5
How to "clear" all previous ShortcutKey Assignments 3

Back
Top