Disabling macros in Excel 2016

[tiredofit]

In previous versions of Excel, if I hold down the shift key whilst opening an excel workbook, macros are disabled.

Alternatively, if the macro security setting is set to "Disable all macros without notification", macros will also be disabled.

However, in the Excel 2106 64 bit version, I have noticed neither of the two methods mentioned disables macros.

My only workaround is:

1. Open Excel manually

2. Set the setting to " "Disable all macros without notification"

3. In Windows explorer, change the name of the Excel file, say to "Copy of"

4. Then open it

Has anyone else experienced this as well?

Thanks

 

[Dryver14]

Have you tried saving the file as .xlsx

 

[tiredofit]

No because it's written in such a way that the code in ThisWorkbook checks to see if you're an authorised user. If not, it won't open, so I don't get the chance to save it as .xlsx (and if I did, all the code will be lost).

 

[Dryver14]

I'm not sure what you want to do then, Are you trying to disable the macros for certain users?

 

[tiredofit]

The program contains code in "ThisWorkbook", ie upon opening the workbook, the code kicks off and verifies whether or not the user is an authorised user or not.

If not, it will not proceed.

I am trying to suppress that part of the code that does the checking, by disabling macros, so it doesn't check it.

 

[Dryver14]

I'm sorry, I don't think we are allowed to provide work arounds for worksheet security

 

[tiredofit]

No worries, I got round it anyway but wanted to know if this behaviour is new to Excel 2016 or not.