VBA Code to automatically allow all macros for a workbook & prevent prompting pop-up?

[jonvanwyk]

This question seems really dumb...even for me. I will have 83 users on 20 different workstations, of which some users will be logged into different workstations on different days. Is there any way to have it so all macros are automatically enabled without having to either (1) enable macros for each session, or (2) permanently change the settings for every profile on every workstation <<< This would be a lot of work!

I know the answer is probably get with our IT department to see if they can do a push to make a universal change to the Macro settings on the network, but I thought I would ask anyway <<< This might be more work than option 2 above! :-/

[davegugg]

Look into creating a local digital certificate. Once created, you can sign the workbook(s). The end users will have to install the digital certificate one time, then they'll never have to worry about enabling macros again. Be sure to read all the warnings about potential security risks of using a digital certificate.

[jonvanwyk]

Our IT department will not issue certificates. My peer in a different division ran into that on his Access Database.

[davegugg]

Well, I don't want to get you in trouble with your IT department, but you can create your own certs. Under the start menu if you go to Microsoft Office -> Microsoft Office Tools -> Digital Certificates for VBA Projects, you can create a simple one that will do nothing but enable others to automatically trust your macros. It doesn't cost anything and in reality, it provides no security. It would be much safer, however, than putting all the users' security settings to Low.

Other than that suggestion, I can think of no way to do what you are requesting.

[royUK]

I'm sure that Digital Certificates using selfcert only work on the machine the certificate is created on. However:


Your post does not comply with Rule 12 of our Forum RULES. Do not post questions with regard to breaking or bypassing a password of any type or post questions with regard to bypassing a users security settings, all such posts will be deleted, repeat offenders will be banned!

Edit:further checking found this way of using the certificate on other machines