Locking certain sheets
 

Hi,

Can you lock certain sheets from being selected in a book. i have alot of
sheets in my book which everyone uses, only they only need to be concerened
with sheets A to J on no thers. Can i lock the book so that only certain
people can use these only and with maybe a password, unlock the rest for
viewing?

Kind regards,

Nigel

You can use the protect sheet option on the Tools Menu.
You can then protect individual sheets.
If you want people to be able to change them give them the password.

If you want something more sophisticated then I think you would need to use
some VB code.

Nick

"Nigel" wrote in message
...
Hi,

Can you lock certain sheets from being selected in a book. i have alot of
sheets in my book which everyone uses, only they only need to be
concerened
with sheets A to J on no thers. Can i lock the book so that only certain
people can use these only and with maybe a password, unlock the rest for
viewing?

Kind regards,

Nigel

Another way would be to hide all the sheets except the ones you want others
to access and password protect the workbook. This also makes sheet selection
easier if there are lots of sheet tabs.
Regards,
Alan,
"Nick" wrote in message
...
You can use the protect sheet option on the Tools Menu.
You can then protect individual sheets.
If you want people to be able to change them give them the password.

If you want something more sophisticated then I think you would need to
use some VB code.

Nick

"Nigel" wrote in message
...
Hi,

Can you lock certain sheets from being selected in a book. i have alot of
sheets in my book which everyone uses, only they only need to be
concerened
with sheets A to J on no thers. Can i lock the book so that only certain
people can use these only and with maybe a password, unlock the rest for
viewing?

Kind regards,

Nigel

There are a number of ways to do this, all documented in the archives:

http://groups.google.com/advanced_gr...ugroup=*excel*

Be aware, however, that XL password protection is for convenience only -
i.e., to keep users from inadvertently messing up your workbook. If
users *shouldn't* see the other sheets, you'll have to come up with a
different solution. Anyone who can find these groups can find ways to
bypass protection in a minute or two. See

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


In article ,
"Nigel" wrote:

Can you lock certain sheets from being selected in a book. i have alot of
sheets in my book which everyone uses, only they only need to be concerened
with sheets A to J on no thers. Can i lock the book so that only certain
people can use these only and with maybe a password, unlock the rest for
viewing?