ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   protect my .xls sheet from being €śmodified€ť and €śsaved as€ť (https://www.excelbanter.com/excel-discussion-misc-queries/121780-protect-my-xls-sheet-being-%E2%80%9Cmodified%E2%80%9D-%E2%80%9Csaved-%E2%80%9D.html)

EFT

protect my .xls sheet from being €śmodified€ť and €śsaved as€ť
 
I need to protect my .xls sheet from being €śmodified€ť and €śsaved as€ť
How could I do this using the VBA for that?
All of which i'm asking you, How to protect my sheet from being "saved as"
when it's in the read only mode.

Thanks for your help.



Dave Peterson

protect my .xls sheet from being“modified” and“saved as”
 
I don't think you can.

Any solution would rely on macros and macros could be disabled. Heck, the user
could just use windows explorer to copy that file anywhere they wanted.

EFT wrote:

I need to protect my .xls sheet from being €śmodified€ť and €śsaved as€ť
How could I do this using the VBA for that?
All of which i'm asking you, How to protect my sheet from being "saved as"
when it's in the read only mode.

Thanks for your help.


--

Dave Peterson


All times are GMT +1. The time now is 09:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com