Sheet tabs not showing - 2003
I have a workbook in Excel 2003 where the only way I can get the sheet tabs
to show is by inserting a worksheet. If I then click on one of the "real" worksheets, the tabs disappear! I do have "show worksheet tabs" checked in Tools-options-view. How do I correct this? thanks. |
"Gordon" wrote in message
... I have a workbook in Excel 2003 where the only way I can get the sheet tabs to show is by inserting a worksheet. If I then click on one of the "real" worksheets, the tabs disappear! I do have "show worksheet tabs" checked in Tools-options-view. How do I correct this? thanks. In fact it's quite weird - this only happens on one sheet. If I'm on that sheet, then the worksheet tabs are missing - if I insert a sheet, the tabs re-appear, and if I go to another sheet, the behaviour is normal! |
Hi
Are you sure that there are no macros on the sheet that might be giving you this strange behaviour? Andy. "Gordon" wrote in message ... "Gordon" wrote in message ... I have a workbook in Excel 2003 where the only way I can get the sheet tabs to show is by inserting a worksheet. If I then click on one of the "real" worksheets, the tabs disappear! I do have "show worksheet tabs" checked in Tools-options-view. How do I correct this? thanks. In fact it's quite weird - this only happens on one sheet. If I'm on that sheet, then the worksheet tabs are missing - if I insert a sheet, the tabs re-appear, and if I go to another sheet, the behaviour is normal! |
<Andy wrote in message ...
Hi Are you sure that there are no macros on the sheet that might be giving you this strange behaviour? Andy. No, there are no macros! |
Any chance that the bottom scrollbar is just covering some of the tabs?
You can resize the scrollbar by dragging the left hand edge right or left. Gordon wrote: I have a workbook in Excel 2003 where the only way I can get the sheet tabs to show is by inserting a worksheet. If I then click on one of the "real" worksheets, the tabs disappear! I do have "show worksheet tabs" checked in Tools-options-view. How do I correct this? thanks. -- Dave Peterson |
"Dave Peterson" wrote in message
... Any chance that the bottom scrollbar is just covering some of the tabs? You can resize the scrollbar by dragging the left hand edge right or left. Gordon wrote: I have a workbook in Excel 2003 where the only way I can get the sheet tabs to show is by inserting a worksheet. If I then click on one of the "real" worksheets, the tabs disappear! I do have "show worksheet tabs" checked in Tools-options-view. How do I correct this? thanks. -- Dave Peterson I'm not sure what the problem was - I copied the data to a new sheet, deleted the "offending" one, and all is now hunkey-dorey! |
All times are GMT +1. The time now is 11:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com