How do I write a Macro that
 

only allows certain users to open a spreadsheet?

How do I write a Macro that
 

mydogpeanut wrote:
only allows certain users to open a spreadsheet?

Have a look at the application.username property. This can be changed in
Tools/Options/General so it is not exactly failsafe.

/Sune

How do I write a Macro that
 

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?

How do I write a Macro that
 

Thanks Jim. I did this. It's probably easier than putting a Macro in any way.

Appreciate the help.

"Jim Thomlinson" wrote:

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?