Thread: Disable Code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan Alan is offline
external usenet poster
 
Posts: 492
Default Disable Code

Hi,
I have a file with a lot of code in it, Macros and Events etc. The goalposts
have moved and I have to alter it a bit. Is there a way to stop any kind of
code from executing to make editing easier?
I know I can open it with Macros disabled then reopen to see if it works,
but it does get very tedious that way..
I've tried
Application.EnableEvents=False in a Macro
But some of the code still seems to run anyway,
Anyone know a way to completely disable all code from running with Macros
Enabled?
Thanks,
Alan.