Home > Software engineering >  The three great god help to solve the problem, thank you.
The three great god help to solve the problem, thank you.

Time:09-28

http://club.excelhome.net/thread-1224759-1-1.html
http://club.excelhome.net/thread-1224682-1-1.html
http://club.excelhome.net/thread-1224640-1-1.html
Links to other web site is in the sorry, please don't delete,
Can reply within this post,
Grateful!

CodePudding user response:

http://www.autohotkey.com

CodePudding user response:

Modify the registry is feasible.
But it must be: in MS Excel closed state changes; And then run the Excel!
Not after it has been running, to modify, it is invalid,

So, if you want to "open" this option, you can write a small program to use VB6 to set, and cannot use macro code to set,
When change the registry, first check whether the Excel in running,
If in the running, do you want to prompt the user to close the Excel, and then change the registry,
So, after the restart the Excel, it can take effect,
  •  Tags:  
  • VBA
  • Related