Hiding Tabs

[Cindy]

I have an Excel spreadsheet that I would like others to
review except for one tab that has payroll information. I
was wondering what is the best/simplest way to be able to
have others review the spreadsheet but not be able to see
the payroll information on the payroll tab. Any help would
be appreciated. Thanks. Cindy

 

[Don Guillett]

Use a macro that uses veryhidden that can only be unhidden with a macro.

 

[BenjieLop]

The simplest way is _*Format/Sheet/Hide*_ though I can not say if thi
is the best way. But it will be kept hidden until you "unhide" it.

 

[Dave Peterson]

This kind of hiding and the protection you'd need to really make is secure isn't
possible in excel.

I wouldn't distribute a workbook containing salaries unless it was ok for all
the people to see them.

 

[Norman Jones]

Hi Cindy,

I would suggest that the surest and safest way would be distribute a copy
workbook which does not include the payroll sheet. If the data in other
sheets pulls information from the payroll sheet, consider converting the
distributed data to snapshot values.

The level of protection afforded by Excel is at best a rudimentary token. A
quick Google search of the Excel NG's will confirm that Excel's protection
mechanisms can be overcome with consummate ease.

You could hide the payroll sheet or, using Don's suggestion, employ a macro
to render the sheet still better hidden; you could also password protect the
sheet. Such steps will, however provide only the flimsiest impediment to
anybody with a modicum of relevant knowledge or, simply, the ability to use
Google.

I would, therefore, strongly advise against distributing sensitive data with
Excel as the sole protection.