Thread: Toggle Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Beep Beep Beep Beep is offline
external usenet poster
 
Posts: 101
Default Toggle Macro

I am using a number of workbooks that need to have the manual calculation
turned on so I can see the number of documents in the filter at the bottom of
the screen, however when I go to another worksheet then I have to either
remember to hit F9 or change the tools option command. I have to filter on
numerous releases.

Any way that I can toggle this option on and off by pressing a couple keys??
Such at ctrl t to turn it on and ctrl o to turn it off.

Thanks