View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Conan Kelly Conan Kelly is offline
external usenet poster
 
Posts: 98
Default Enabling/Disabling Macros w/o closing & re-opening

Hello all,

Is there a way to enable and disable macros without having to close the file and re-open it?

One of the files that my boss has designed has macros running when you switch from tab to tab, making it impossible to copy-&-paste
from sheet to sheet. I would like to be able to disable macros, do my copy & paste, and then re-enable macros without having to
close my file. Is this possible?

--
Thanks for any help anyone can provide,

Conan Kelly