thanks to all. This is great info!!
"Jim Thomlinson" wrote in message
...
Excellent link... I had not seen that one. I have code to crack passwords
but
that is good insight into what Excel is doing and why it is so easy to
crack.
Always good to learn something new... Thanks Tom and JE
--
HTH...
Jim Thomlinson
"Tom Ogilvy" wrote:
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