how to write Excel VBA to make macro security automatically set to low...?

Question

i want to write the script under Workbook_Open() so user of my excel program don't need to choose whether to select enable or disable macro.. please help, tq.

Answer 1

The guy who mentioned about getting your macro certified is right. Just do a search for certifying macros in Excel. It will take you to a Microsoft website where you can download a little program to certify your macros. Then whoever uses your macros can specify that you are a trusted source. This allows them to keep their macro security levels to high but to still be able to open your macros and use them.

Answer 2

Rather than do that why not certify the macro so it is trusted. This way you will not be bothered by the question of whether the code is safe or not.

Answer 3

finding on your version of place of work, via fact the previous poster noted, having macros run while a workbook opens may be puzzling. by utilising default Excel would not enable macros to run without the consumer extraordinarily allowing them. you may enable that habit by utilising enhancing macro risk-free practices and allowing all macros to run, yet that it somewhat no longer stated. you may desire to attempt putting a message on the 1st worksheet and then enhancing that message as quickly as macro are enabled by utilising the consumer, yet that would desire to require putting the message returned on the workbook close journey.

Answer 4

You would be better off asking this question in the microsoft community for XL or VBA. Below is the link to take you there. You will need to sign up (it is free)

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.excel.links&tid=c543d314-3927-452e-97cd-6b8b536a47bf.

Answer 5

I don't think you can, that's kind of the point.

teef_au