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

[Guest]

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