I have a feeling this can't be done.....
Excel File with Macro (that does loads of stuff.....etc....)
Then saves as a new file name.
When a new user opens the resulting file - they still get the 'enable amcro' option.
I don't want users to alter their security.
Is there a way to force the Macro to:
1- Do its Stuff
2-Save as new filename
Its part 3 that is niggling me.....
I don't want less IT-persons to see that message as many freak out thinking that its a spawn of the Y2Killer-Syndrome Wormathon Bug trying to destroy their PC..... when will they learn.....