Error while running VBS script

Question

I am trying to run excel macro using VBS and getting attached error. Is there a way to enable macro at the run time? if so, how?

Right click file - Properties - Unblock.

ACatInLove
– ACatInLove

2018-02-13 09:52:44 +00:00
Commented Feb 13, 2018 at 9:52 — ACatInLove
– ACatInLove, Commented Feb 13, 2018 at 9:52

Vityata · Accepted Answer · 2018-02-14 11:33:48Z

2

This should be done in Excel itself:

Click the File tab and then click Options.
Click the Trust Center tab and then click the Trust Center Settings button.
Click "Enable all macros" Note - it is not recommended for a reason to do so!
Set the checkbox to "Trust access to the VBA project object model"

edited Feb 14, 2018 at 11:33

answered Feb 13, 2018 at 10:14

Vityata

43.8k10 gold badges64 silver badges110 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

L42 Over a year ago

I stand corrected, DisplayAlerts set to False my not be able to kill the pop-up. Although it worked for me even on network files. I however checked my Trusted Document and Trusted Location list and most (not all) of the files I execute macro from are there. But then again, I have distributed VBS file to many different users and it works just by using the DisplayAlerts = False. Anyhow, if the OP confirms it does not help, I'll delete it for now. Cheers! :)

Vityata Over a year ago

@L42 - yup, the checkbox is important.

Collectives™ on Stack Overflow

Error while running VBS script

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related