problem after protect file

[eugz]

Hi All.
I created excel form with calculated formula and macro. Everything worked fine. To protect spreadsheet formula I protected file. But after protection when I ran file I get macro error message. Then I remove protection become work without error messgae. How to fix that problem?
Thanks.

[royUK]

What macro message error?

What code are you using before getting the error?

[Simon Lloyd]

What was the code you ran? what was the error? what range is protected?

[Simon Lloyd]

Ouch!................mind my toes!

[eugz]

Run-time error '1004'
Unable to set the Color property of the Font class

Please Login or Register  to view this content.

Thanks.

[royUK]

You need to unprotect first

Please Login or Register  to view this content.

[eugz]

Hi RoyUK.
Happy New Year. Thanks for help. That works.