Hi Ray,

The macro itself works fine; my problem lies in the fact that all
users can open the macro if they so desire and view the password,

set a vba-project password, users will not be able to open and see your
macros.

Set the pwd in VBA-Editor/Extras/PropertiesofVBAProject/Protection -
hide the project and enter a password.

This password can be cracked, however, it is a bit tricky and too hard
for "normal" users. Again, this pwd is harder to crack than sheet or
workbook passwords, there's no qick to find download for it but it CAN
be cracked easily if sbd. wants to.

arno