I have been using a macro on an excel document that zooms in charts present in any sheet. The problem is, if I want to edit a chart, I must click it, triggering the zoom.
For this particular reason, I need to disable macros, and was wondering if there is either an easy to reach button or a keyboard shortcut to toggle it.
In the XL file:
1) Press Alt+F11
2) Go to the ThisWorkbook module and comment out the two lines inside both subs.
3) Save and close the file, then reopen.
4) You can then edit to your hearts content.
5) To put the zoomer back on, uncomment the lines. You may need to Save, Close and Reopen again
NB -> see comments on original post for more information.