Good evening Clive

Macros are pretty powerful things can irreversibly damage or remove
files and for this reason Microsoft have implemeted some protection for
the user from rogue macros. You have a few possible actions:
1. Set your macro security to low - not recommended for obvious
reasons, and anyway a user could easily reset it to medium to prevent
the macro from running.
2. Purchase yourself a digital certificate and set yourself up as a
trusted source so that macros signed by you will run unchecked.
3. Design the macro as a seperate file run as an add-in as this will
run without giving the user the chance to cancel it.
4. Save the file with all the sheets (except perhaps a warning sheet
telling the user that macros must be run) hidden (or xlVeryHidden) and
use a macro to unhide all the sheets and hide the warning sheet.

Be aware that none of these methods is foolproof and if someone really
wanted to break your system and access information that perhaps they
shouldn't then you will struggle to stop them with Excel.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=472333