Make Workbook Read-Only and Not Saveable Upon Close

Hi all,

I have the following procedure:

Please Login or Register  to view this content.

What I want to do if the workbook name is IPI Locater.xlsm is make it read only and also not give the user the ability to save the file. The reason for these criteria is because this particular file is going to be used on our corporate intranet and I need control over the workbook so that people will not be able to change the data in our department's shared drive. Any takers on this?

Regards:

You could easily make the workbook Read Only by changing its attributes on the server ... and ensuring that only you and the Administrators have Full Access to the file so no-one can take ownership or change the attributes.

However, with regard to preventing it from being saved, I think that's a bigger problem. You could do this in the code but you only need to disable macros and you can do what you like with it.

Regards

Hi TMShucks and thanks for the info! I'll do as you say and change the file to read only on the server. As for my other problem, I need the users to enable the macros because the workbook's charting options use macros.

Remember also to change the permissions so that only you (and Admin) can change or delete the file.

With regard to the macros, if it were me, I'd not enable the macros and then save the workbook elsewhere ... where I'd probably run a password cracker on it.

To a large extent, it depends on who and what you are trying to protect against. If your users/clients are very Excel knowledgeable, passwords in Excel aren't generally a problem. But best not to talk about that ;-) If you simply want to protect your template from being corrupted, read-only should do that. I think the attributes would be copied with the file but I'm not sure so you need someone, not you, to test that.

Regards

Regards

Thanks TMShucks. The workbook has 4 hidden sheets and one sheet, the charting tool sheet, that is viewable (this is not a word-yet). I will set it to read only like you said (with permissions like you said) and I might go as far as password protecting the sheets instead. I want to do this because I don't want someone to change the data and save it accidentally. If that happens, the data (which will be corporate accessible) will be wrong and I will look bad. I definitely don't want that to happen.

Thanks for you help.