I have a template which contains a macro. I would prefer
the users who use this template not be aware the macro is
there. i.e. I don't want any 'enable/disable macros Y/N'
popup windows appearing. I don't want the users to be able
to run the macro.
The users will fill in the spreadsheet data and email it
back to me. I will then run the macro to create a new
worksheet from the enetered data.
Is this possible? Or, is there a better way to do it?