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.

AEK wrote:

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

--

Dave Peterson