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?

Improve this question

1 Answer 1

Reset to default
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.
Improve this answer
2
  • i can't manually change the trusted sites for each excel files. i'm looking for a way to autmatically suppress the macros.
    – athos
    Commented Jun 16, 2017 at 5:27
  • Unfortunately, currently there is no automatic suppression other than using Trust Center.
    – Vylix
    Commented Jun 16, 2017 at 5:42

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .