quick way to prohibit all editing/changes to workbook (2010)

  • Thread starter Thread starter oldyork90
  • Start date Start date
O

oldyork90

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.
 
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.
Click to expand...

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
 
Back
Top