I need to protect cells that contain formulas but on a huge scale.

[BR]

In Excel, I need to protect cells that contain formulas but for thousands of
files and sheets. The real trick is being able to go back into these files
and allow macros to operate properly while under protection. Any suggestions?
Thanks

[dominicb]

Good evening BR

You can use a piece of code at the start of your module that will allow macros to run without problem on protected sheets :

ActiveSheet.Protect UserInterfaceOnly:=True

This will allow your macro to make changes to your sheet with the protection still in place. This will not automatically take effect every time the workbook is opened, so you would have to tie it to an event procedure to run it every time the file is used.

HTH

DominicB