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

[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

[PaLPiTaTioN]

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

Anyone?

[SirJim]

This error can be caused by the name of the folder (or previous folder) where the xls-file is located in...
When the foldername (or name of a previous folder) contains the character "[" and/or "]", you get this error.
For example when your xls-file is located in
"C:\XLS-files\] Test\bladibla.xls" or "C:\] XLS-files\Test\bladibla.xls"),
you will get the 'Formula is too complex to be assigned to object'-error.

By the way: Other special characters in foldernames (like "+", "(" and "{") won't cause that problem.

You like to maintain your foldername?!
In that case you:
-> move the xls-file to "C:\" (e.g. "C:\bladibla.xls")
-> open bladibla.xls
-> add the macro's to the buttons
-> save & close the xls-file
-> move back the xls-file to your desired location (e.g. "C:\] XLS-files\Test\bladibla.xls")

It works for me... hope it works for you too

[euveng]

It works. A ridiculously simple fix but didn't realize it. Thanks!

Ev