Automatically enable macros for particular template

B

Bryan Linton

Users in our sales department regularly use a particular Excel template that
requires macros. Other than globally lowering the macro security level,
what can I do to allow macros automatically just for that one template? I
want to eliminate the user prompt regarding macro security.

Thanks,

Bryan
 
N

Nick Hodge

Bryan

No point in security if it's too easy. You can install it as an addin or
sign it with a certificate...that's realistically all

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Global Template Network and saving auto texts & macros 2
Quicker way to enable macros? 3
Issue With Macro Sheduling Using On Time Event 0
Select text of a particular shading color (VBA macro) 5
Want to have macro execute automatically when doc created 3
Automatically Enable Macros on specific Template 2
Macro security level 6

Top