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