Forum Discussion
sunnyschindler
Oct 11, 2021Brass Contributor
keyboard-shortcut or command-line-option to disable multiple Excel features temporarily
I need a Workbook stripped of all functionalities and features. When opened
- a Window of 1 column 4 rows shows
- End-User paste into 1 cell from Clipboard into 1 cell only
- hit F9 to Calc
- copy another cell into clipboard.
- Close Workbook; other Workbooks will not be used when this Workbook is opened.
Similar to Microsoft Calculator App in shape & form but different function. Ideally, this Workbook can be configured for best performance sacrificing aethestics and features (e.g. Add-In, Ribbon, Proofing, Scroll-Bar)
Unfortunately, many features (i/c Add-Ins) I like to turn-off
- affect all open Workbooks
- no keyboard-shortcut to disable multipe features temporarily.
- no command-line option to open another Xl instance with disabled features .
- I understand VBA can temporarily do this but since my company restrict VBA, is there a Microsoft endorsed source-code for this? Alternatively, is there best practise?
3 Replies
- edawcjBrass ContributorI don't believe what you are looking for actually exists outside the use of very specialized code.
- sunnyschindlerBrass ContributorSituation (preference for non-programming solution) looks like best alternative is reliable code, I would appreciate if anyone advise if there is pay add-in when free don't seem available.
- sunnyschindlerBrass ContributorAlternative is using VBA SendKey sequences which is more wrist-friendly than manually click on each feature to disable non-essentials.