| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i lock tabs so that only an admin can edit them?
Can anyone help? I'm trying to create a read-only copy of a worksheet, and it
would be preferable to either lock the tabs along the bottom, or hide them completley, to be unlocked with a password for admin. Many Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i lock tabs so that only an admin can edit them?
If you want to hide the tabs, you can use:
tools|options|View tab|Uncheck Sheet Tabs I'm not sure what lock means--maybe protecting the workbook's structure? Tools|Protection|protect workbook|Check Structure Dave_FFM wrote: Can anyone help? I'm trying to create a read-only copy of a worksheet, and it would be preferable to either lock the tabs along the bottom, or hide them completley, to be unlocked with a password for admin. Many Thanks -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i lock tabs so that only an admin can edit them?
Thanks very much that did the trick
"Dave Peterson" wrote: If you want to hide the tabs, you can use: tools|options|View tab|Uncheck Sheet Tabs I'm not sure what lock means--maybe protecting the workbook's structure? Tools|Protection|protect workbook|Check Structure Dave_FFM wrote: Can anyone help? I'm trying to create a read-only copy of a worksheet, and it would be preferable to either lock the tabs along the bottom, or hide them completley, to be unlocked with a password for admin. Many Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Admin Password for multiple workbooks | Excel Discussion (Misc queries) | |||
| Lock a cell from others to edit? | Excel Worksheet Functions | |||
| Enhancement Request: Give us ability to lock/freeze tabs in Excel | Excel Worksheet Functions | |||
| Note to Admin | Excel Discussion (Misc queries) | |||
| need to upload copied excel files to admin page on website | Excel Discussion (Misc queries) | |||
Linear Mode
