Does anyone know how to hide and protect sheets within a workbook. I am
trying to set up a company budget workbook that will go out to several
departments. I want everyone to use the same workbook, but do not want them
to be able to see department budgets that are not related to them. I would
like to keep all sheets in the same workbook to avoid formula errors in
aggregating the data. Thanks for any help.

You can set the sheets to xlVeryHidden in the propery window of the
VBE. However, I honestly would not recommend putting something as
secure as budget data in a workbook with everyone else's budget data.
While it is true that Excel offers some protection, it is not full
proof and cracking products and code snippets are readily available if
someone decided to give it a shot. I would recommend setting up a
template (.xlt file) and then base all of the budgets off of that
template.
Ridge wrote:
Does anyone know how to hide and protect sheets within a workbook. I am
trying to set up a company budget workbook that will go out to several
departments. I want everyone to use the same workbook, but do not want them
to be able to see department budgets that are not related to them. I would
like to keep all sheets in the same workbook to avoid formula errors in
aggregating the data. Thanks for any help.

It can be done through VBA and passwords but make note that Excel's internal
security is quite weak and passwords can be broken.

Sheets would be hidden and each user's sheet could become visible if they enter
theit password.

Also you would need a contingency plan if users decide not to enable macros when
opening the workbook or if their macro security settings are at high or very
high.

You may be better off giving them their own workbook and you set up a master
workbook that links to these.

The general rule is.........if you don't want someone to view data in an Excel
workbook, don't include it in that workbook.

If you want sample code to hide and unhide sheets post back.


Gord Dibben MS Excel MVP

On Tue, 2 Oct 2007 13:01:01 -0700, Ridge
wrote:

Does anyone know how to hide and protect sheets within a workbook. I am
trying to set up a company budget workbook that will go out to several
departments. I want everyone to use the same workbook, but do not want them
to be able to see department budgets that are not related to them. I would
like to keep all sheets in the same workbook to avoid formula errors in
aggregating the data. Thanks for any help.