Why don't you just put the macros in an add-in?

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
oups.com...
Hi,

I am working with a lot of worksheets which sit on a network share and
are accessed by various users, all these users have macro settings to
High and I don't want them having access to embedded macros, as I need
to have a batch job run on a stand alone PC which will run a specific
macro on all these sheets every week.

I use a scheduled VBS script to launch the sheets and run the macros.
What I would like to do is remove all the macros from the worksheets as
the security level provides a nag screen each time a new user opens the
sheet. Ideally I would like one XLS file sitting on the stand alone PC
which opens all the sheets and then runs the macros from one file. Is
this possible? (does it make sense?) I know there are workarounds such
as digitally signing macros etc..although as its the same macro in a
number of sheets, I'd rather only edit it once, and I want to eliminate
the macro security pop up box. Anyone have any ideas?

Thanks!

Keilan