Hello,

Is it possible to force a file to open read-only for certain users.

Thank You,

Not really, but you can disable the Save and Save as options on open
workbook, and since you want to limit the number of users you may want to
insert a list of user id's and passwords either on a hidden sheet or inside
your code to allow only some users to be able to save and save as.

"tjh" wrote:

Hello,

Is it possible to force a file to open read-only for certain users.

Thank You,

Thanks,

I have a function to access the user id's, but what would the code look like
to disable the Save option

"Michael" wrote:

Not really, but you can disable the Save and Save as options on open
workbook, and since you want to limit the number of users you may want to
insert a list of user id's and passwords either on a hidden sheet or inside
your code to allow only some users to be able to save and save as.

"tjh" wrote:

Hello,

Is it possible to force a file to open read-only for certain users.

Thank You,

Save the file with a password to modify. Share that password with only the
users you want to have it.

The other users will be able to open the file as readonly.

tjh wrote:

Hello,

Is it possible to force a file to open read-only for certain users.

Thank You,

--

Dave Peterson