DISABLE MACROS ON A PARTICULAR FILE

[VDS]

Dear Colleagues,

I am trying to open the file named "M:\Old\Total Data of projects" as per the attached screenshot. The file gives the security warning message of Macro "Disable / Enable / More info". Once it is enabled, file is open and takes so much time to activate. Is it possible to disable macro on this particular file whenever it is opened ? Just like in other programming applications like On load, On Open, On close, etc.


VDS

 

[SirJB7]

Hi, VDS!
Tried holding pressed Shift key when opening the file?
Otherwise put a message box with Yes/No at top of the workbook open event code.
Regards!

 

[VDS]

Hi, VDS!
Tried holding pressed Shift key when opening the file?
Otherwise put a message box with Yes/No at top of the workbook open event code.
Regards!

 

[VDS]

Sir,

I am not able to disable macro while holding the shift key. I came to know the below function can be helpful.

Sub MACRO_DO_SOMETHING()

Application.EnableEvents = False

Workbooks.Open FILENAME:="FILE_NAME.xls" PASSWORD:="XYZ"
RUN_OPERATION
Workbooks("FILE_NAME.xls").Close SaveChanges:=False

Application.EnableEvents = True
End Sub

However, this can function be worked only on a macro enabled worksheet.

As stated above, my particular file can open quickly if macros are disabled.

Could u please suggest any solution.


VDS

 

[Abhijeet R. Joshi]

Set your macro security to medium, so you will be asked to enable a macro or not...
Should this help?

 

[VDS]

@ Abhijeet Sir,

This is already in medium. Is there any other way to extract complete vb code from the file. I am unable to attach the file. If the VBA code has been deleted from the file, it will open quickly. But the entire function from Personal.XLS will be washed out creating little bit of hectic.

Could you please sort out.

VDS

 

[SirJB7]

Hi, VDS!
Give a look at the uploaded file. If you press and keep the Shift key until the workbook is opened macros do not run and no message box is displayed.
Regards!