Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
EFT EFT is offline
external usenet poster
 
Posts: 1
Default 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.


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default protect my .xls sheet from beingmodified andsaved 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"