R
Roxy
Am I able to hide the tabs to a worksheet?
Thanks
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
DanRoss
Yes - what versoin of excell?
D
Dave Peterson
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.
Tools|Options|view tab|uncheck sheet tabs
Be aware that the user can use ctrl-pgup and ctrl-pgdn to move between sheets.
R
Roxy
I am working with the 2003 version. Thanks!
DanRoss said:Yes - what versoin of excell?
R
Roxy
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!
the specific sheet. Do you think that is possible rather then just changing
the sheet option? Thanks!
D
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.
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.