![]() |
#8
|
|||
|
|||
![]()
I made my own toggle using Macro Express Pro. It works by sending the exact sequence of keys that gets the job done. A few delays are needed, which I've included.
Consider downloading the evaluation copy of Macro Express Pro. Recreate my script. Then you can decide whether the convenience is worth $80! No guarantees. Use at your own risk! Text Type (Simulate Keystrokes): <ESC> // Try to cancel whatever might be in process Text Type (Simulate Keystrokes): <F10> // Activate ribbon Text Type (Simulate Keystrokes): v // View Text Type (Simulate Keystrokes): v // View Settings Text Type (Simulate Keystrokes): o // Other settings Delay: 100 milliseconds Text Type (Simulate Keystrokes): <ALT>a // Allow in-cell editing checkbox Delay: 3000 milliseconds Text Type (Simulate Keystrokes): <ENTER> // OK button Delay: 200 milliseconds Text Type (Simulate Keystrokes): <UP ARROW><UP ARROW><UP ARROW><UP ARROW> // Navigate to top item in leftmost column of buttons Text Type (Simulate Keystrokes): <SHIFT><TAB><SHIFT><TAB> // Navigate to OK Text Type (Simulate Keystrokes): <ENTER> // Activate OK Or paste in this code in the Macro Express Script Editor: <TEXT TYPE Action="0" Text="<ESC>" _COMMENT="Try to cancel whatever might be in process"/> <TEXT TYPE Action="0" Text="<F10>" _COMMENT="Activate ribbon"/> <TEXT TYPE Action="0" Text="v" _COMMENT="View"/> <TEXT TYPE Action="0" Text="v" _COMMENT="View Settings"/> <TEXT TYPE Action="0" Text="o" _COMMENT="Other settings"/> <DELAY Flags="\x02" Time="100"/> <TEXT TYPE Action="0" Text="<ALT>a" _COMMENT="Allow in-cell editing checkbox"/> <DELAY Flags="\x02" Time="3000"/> <TEXT TYPE Action="0" Text="<ENTER>" _COMMENT="OK button"/> <DELAY Flags="\x02" Time="200"/> <TEXT TYPE Action="0" Text="<UP ARROW><UP ARROW><UP ARROW><UP ARROW>" _COMMENT="Navigate to top item in leftmost column of buttons"/> <TEXT TYPE Action="0" Text="<SHIFT><TAB><SHIFT><TAB>" _COMMENT="Navigate to OK"/> <TEXT TYPE Action="0" Text="<ENTER>" _COMMENT="Activate OK"/> |
Tags |
macros, on-off, toggle |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to protect a cell from editing | otuatail | Excel | 1 | 10-11-2022 12:09 AM |
Macro for zooming toggle | dovel | Word | 2 | 07-31-2020 02:32 PM |
![]() |
gloub | Word VBA | 2 | 01-30-2019 12:40 PM |
![]() |
Jennifer Murphy | Word VBA | 3 | 01-22-2014 11:22 PM |
Macro to toggle outline level | Jennifer Murphy | Word VBA | 0 | 07-08-2013 08:20 AM |