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?