View Single Post
 
Old 03-05-2024, 02:44 PM
AlanCantor AlanCantor is offline Windows 10 Office 2019
Competent Performer
 
Join Date: Nov 2020
Posts: 153
AlanCantor is on a distinguished road
Default

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"/>
Reply With Quote