View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default quick way to prohibit all editing/changes to workbook (2010)

I can protect cells and workbooks, but say I have a wb that isn't
isn't really setup to use those two macros (Protect Sheet, Protect
Wookbook). Is there an over all switch I can flip that simply says
"YOU CAN CHANGE NOTHING"

I'm not looking at this as a security issue, just one of sharing
quick and dirty sheets with others and precluding their inadvertent
changes --- kind of a PDF with scroll bars.

Thank you.


Save it as 'Read Only', perhaps!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion