Am I able to hide the tabs to a worksheet?

Thanks

Yes - what versoin of excell?


"Roxy" wrote in message
...
Am I able to hide the tabs to a worksheet?

Thanks

In xl2003:
Tools|Options|view tab|uncheck sheet tabs

Be aware that the user can use ctrl-pgup and ctrl-pgdn to move between sheets.

Roxy wrote:

Am I able to hide the tabs to a worksheet?

Thanks

--

Dave Peterson

I am working with the 2003 version. Thanks!

"DanRoss" wrote:

Yes - what versoin of excell?


"Roxy" wrote in message
...
Am I able to hide the tabs to a worksheet?

Thanks

Oh okay thanks. I am trying to use a contol button to allow users to unhide
the specific sheet. Do you think that is possible rather then just changing
the sheet option? Thanks!

"Dave Peterson" wrote:

In xl2003:
Tools|Options|view tab|uncheck sheet tabs

Be aware that the user can use ctrl-pgup and ctrl-pgdn to move between sheets.

Roxy wrote:

Am I able to hide the tabs to a worksheet?

Thanks

--

Dave Peterson

Sure.

You can protect the workbook ("tools|protection|protect workbook" manually).
This will stop the user from moving, deleting, inserting, hiding, unhiding
sheets.

Then your code could unprotect the workbook, unhide the worksheet, and then
reprotect the worksheet.



Roxy wrote:

Oh okay thanks. I am trying to use a contol button to allow users to unhide
the specific sheet. Do you think that is possible rather then just changing
the sheet option? Thanks!

"Dave Peterson" wrote:

In xl2003:
Tools|Options|view tab|uncheck sheet tabs

Be aware that the user can use ctrl-pgup and ctrl-pgdn to move between sheets.

Roxy wrote:

Am I able to hide the tabs to a worksheet?

Thanks

--

Dave Peterson


--

Dave Peterson