View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
J.E. McGimpsey J.E. McGimpsey is offline
external usenet poster
 
Posts: 493
Default Question about Protecting a Workbook

No. You can throw up some roadblocks using VBA, but they're easily
defeated by anyone with enough savvy to read these newsgroups.

Saving the file as Read-Only (Save As/Options) at least forces them
to use a different name (but doesn't prevent them from doing a
SaveAs, then changing the name back.


In article ,
"TBA" wrote:

Excel 2000
Windows 2k Pro

Is there a level of protection that I can set whereby a user can edit/change
a workbook all they want EXCEPT that they can't save it?

TIA.

-gk-