How to stop VBA script so I can update worksheet

[Cgalla87]

Hi All,

I have a VBA script running in a doc and it has a password protect function on it. Essentially locks down all the sheets so only the editable cells remain open. I need to make format and other changes to the document, how do I stop the script from running so I can make all my changes then restart it after I’m done without breaking it? Not a code change just need it to stop locking the document ever time I change one cell.

 

[ranman256]

turn off the macros:
File, options, trust center, trust center settings, macro settings, DISABL ALL MACROS (with or without warning, your choice)

 

[mole999]

is it a doc (word) or is it a sheet (excel), I have a simple method for excel I use

 

[Cgalla87]

Hi Ranman,

Can I make all the changes I need then enable them again without anything breaking?