Yea, I got that.

I was hopin to comment out the protection only and still be able to run
everything else.

Thank You

"Dave Peterson" wrote:

Run Gord's disable_events procedure before you start your development work.

Do all your changes.

Run the enable_events when you're done making changes and ready to test.

Gizmo wrote:

Hi Gord,

I still want to be able to run the prucedures to make sure my "fixes" work.
I just don't want to have to unprotect after every button click.
"Gord Dibben" wrote:

Try disabling events while debugging.

Sub disable_events()
Application.EnableEvents = False
End Sub

Sub enable_events()
Application.EnableEvents = True
End Sub


Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 11:44:16 -0700, Gizmo
wrote:

Excel2003 and 2007

I have an application that has worksheet and workbook unprotection and
protection at the begining and end of every procedure. When I have to do any
debugging, everytime i change a view or click on a button my workbook and
sheets are reprotected.

Is there a way (Easy) to comment out all the protection while i'm debugging
and then un-comment it after i'm done?

I was thinking maybe a sub routine i can assign to a button.

Is it possible to use macro recorder inside the VBE?



--

Dave Peterson