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

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

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