0

I've asked similar questions before, about How to add an “open in new excel” in windows file explorer context menu? and How to add a "duplicate this folder" in windows file explorer context menu? .

Similarly, is there an easy way, to add an item to windows explorer's context menu, i.e., when right click on a folder "X", there's a new item "open this in new excel with macros disabled", such that after clicking, the file will be opened not in current excel sessions, but in a new excel window, and the macros will be disabled, i.e. events such as Workbook_Open() won't be triggered?

1

Taken from source

Hold down Shift while the workbook is opening. Unfortunately there is no parameter can be set on a shortcut to disable macro.

You can also set Disable Macro and set a trusted location so it will automatically disable macros but from files opening from the trusted location.

Setting Macro Security in Office 2013

  1. Go to File > Options > Trust Center
  2. Select Macro Settings
  3. Select either Disable all macros without notification or Disable all macros with notification (recommended)
  4. Select Trusted Locations
  5. Select Add New Location to make a folder trusted location.
  • i can't manually change the trusted sites for each excel files. i'm looking for a way to autmatically suppress the macros. – athos Jun 16 '17 at 5:27
  • Unfortunately, currently there is no automatic suppression other than using Trust Center. – Vylix Jun 16 '17 at 5:42

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.