ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   When I load a previous Excel workbook I lose my worksheet tabs. (https://www.excelbanter.com/excel-worksheet-functions/134381-when-i-load-previous-excel-workbook-i-lose-my-worksheet-tabs.html)

DRK

When I load a previous Excel workbook I lose my worksheet tabs.
 
When I load a previously constructed workbook, I can only access the first
page of the workbook. I have no tabs at the bottom to maneuver to other
sheets. How do I get them back?

Data Miner

When I load a previous Excel workbook I lose my worksheet tabs.
 
You can right click on the page tab and insert blank sheets

"drk" wrote:

When I load a previously constructed workbook, I can only access the first
page of the workbook. I have no tabs at the bottom to maneuver to other
sheets. How do I get them back?


MartinW

When I load a previous Excel workbook I lose my worksheet tabs.
 
Or maybe you are talking about hidden sheets.
You can retrieve them by FormatSheetUnhide

HTH
Martin


Gord Dibben

When I load a previous Excel workbook I lose my worksheet tabs.
 
Maybe ToolsOptionsView. Checkmark in "Sheet Tabs"


Gord Dibben MS Excel MVP



On Sun, 11 Mar 2007 16:29:00 -0700, drk wrote:

When I load a previously constructed workbook, I can only access the first
page of the workbook. I have no tabs at the bottom to maneuver to other
sheets. How do I get them back?




All times are GMT +1. The time now is 03:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com