Workbook Protection

[Guest]

I have a 26 worksheet workbook. Various rows (different on each worksheet)
need to be hidden when I send this out. Only way I have been successful
protecting this from being unhidden is to protect every worksheet.
Protecting the workbook doesn't do it. Very time consuming and quite
inefficient when I need to unprotect. Any suggestions?

 

[Anne Troy]

Anne... lots of people can unhide those sheets. Why will you send them at
all? Why not copy your "good" worksheet to another workbook by itself, and
just send that? If you tell us exactly what you're looking to do, we may
have macros that already do it over at www.vbaexpress.com in the
Knowledgebase.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Dave Peterson]

And just to reiterate. If that data shouldn't be seen by any one else, don't
put it in the workbook--or don't share the workbook.

The worksheet protection, as well as workbook protection (via tools|Protection)
is easily broken.

If it's private info, don't share it.