Just some added information:

If your managers are motivated to see the sheets of other managers, then
here is a link to code (readily available and well known) to quickly remove
any protection based on built in excel capabilities that you might choose to
implement, particularly all those methods (that actually hide information)
already suggested.

http://www.mcgimpsey.com/excel/removepwords.html

--
Regards,
Tom Ogilvy


"Dan B" wrote in message
...
Wow....sounds great, but I have no clue how to do that. You gave me a
good
start in the right direction on researching how.

Thanks for the info and your help.

Dan


"Jim Thomlinson" wrote in message
...
Hide (xlVeryHidden) all of the sheets except a Main navigation sheet.
Validate the user by their NT User Name ( In VBA environ("UserName"))
checking it against a list of names stored on a sheet somewhere. Based
on
who
has the book open unhide their departemantal budget sheet. Make sure to
protect your code so that no one can get into the sheets through the
back
door.
--
HTH...

Jim Thomlinson


"Dan B" wrote:

Hi,

Here's what I would like to do. I want a spreadsheet for an annual
budget.
I would want a separate worksheet for each department and another sheet
that
would summarize all departments. It would be shared on the network so
each
department manager can enter their budget request.

Is there a way to protect each sheet with a different password so that
each
department manager can see only their worksheet and not the other
departments or the summary sheet. So, if they were to click on a
worksheet
tab, they would have to put in a password before they could even see
it.
That may be asking too much. Is there some way to accomplish this?

Thanks
Dan