Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Protection and Hiding Sheets | Excel Discussion (Misc queries) | |||
Sheets Skip Macro | Excel Discussion (Misc queries) | |||
Multiple sheets selected | Excel Discussion (Misc queries) |