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.

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

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

On Mar 12, 11:43*am, GS wrote:
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 athttp://www.eternal-september.org
Classic VB Users Regroup!
* comp.lang.basic.visual.misc
* microsoft.public.vb.general.discussion

DAMN! hahahah