How can i protect a file from saving by other user

[IVONNEMC]

I have an excel file where i manage it and nobdy else is allowed to save the excel worksheet in their computers.

Is there a way to avoid saving the worksheet by other user in their computers?

Thanks

 

[brettdj]

Not foolproof if the file must be shared (otherwise you could of course just use a password)

The best you can do would be to use code to check that the workbook was being saved to your computer (using a unique network computername, or a more detailed WMI checking for specific info). Which in turn means you need to try to enforce using macros - this is typically done by hiding all the sheets with passwords then using code on start-up to unhide them. If macros are not enabled the sheets are left unhidden and the user is directed to a splash screen saying "please enable macros"

But these techniques are easily bypassed by someone with basic VBA knowledge, and tools that unlock VBA and sheet protection are also widely available

Regards

Dave

 

[IVONNEMC]

Dave
Thanks for your reply but this was not clear.
is there a way to put a macro where the SaveAs button is disabled when the spreadsheet is protected?

 

[brettdj]

Yes. You can try disabling SaveAs with code but:
1) What if macros are disabled (or the user chooses to disable them)
2) What is to stop the user emailing / simplying copying the file over the network

You might be able to stop inadvertent copying but really have no options to secure your file against a determined user, other than password on file open

Cheers

Dave