Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 03-05-2024, 02:44 PM
AlanCantor AlanCantor is offline Toggle on & off Allow in-cell editing -or- a macro to do this Windows 10 Toggle on & off Allow in-cell editing -or- a macro to do this 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
 

Tags
macros, on-off, toggle



Similar Threads
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
Toggle on &amp; off Allow in-cell editing -or- a macro to do this Toggle between upper case, lower case, etc... by one single macro on a Mac, to emulate Shift + F3 on gloub Word VBA 2 01-30-2019 12:40 PM
Toggle on &amp; off Allow in-cell editing -or- a macro to do this Macro to toggle outline level 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft