Generally speaking macros are easy to defeat in terms of security. Why not
use password protection. File - Save As - Tools - General Options -
Password. Now the only wat to open the spreadsheet is with the password.
--
HTH...

Jim Thomlinson


"mydogpeanut" wrote:

only allows certain users to open a spreadsheet?