View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gizmo Gizmo is offline
external usenet poster
 
Posts: 47
Default possible to record vba editing as a macro

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?