ExcelBanter - Worksheet shrinks in size in Excel 2000

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Worksheet shrinks in size in Excel 2000 (https://www.excelbanter.com/excel-discussion-misc-queries/3741-worksheet-shrinks-size-excel-2000-a.html)

keith253

Worksheet shrinks in size in Excel 2000

new When my 12-sheet workbook was renamed, each worksheet within the workbook
shrank. There are no resize buttons available to cause it to fill the pane
again. Please advise.

LoriM

Do you mean the zoom size when working on your sheets OR are you in
PrintPreview? Please give a bit more detail. Thanks!

"keith253" wrote:

new When my 12-sheet workbook was renamed, each worksheet within the workbook
shrank. There are no resize buttons available to cause it to fill the pane
again. Please advise.

Gord Dibben

Keith

Sounds like you renamed then saved with the workbook protection enabled.

ToolsOptionsUnprotect Book

Gord Dibben Excel MVP

On Thu, 13 Jan 2005 06:01:05 -0800, "keith253"
wrote:

new When my 12-sheet workbook was renamed, each worksheet within the workbook
shrank. There are no resize buttons available to cause it to fill the pane
again. Please advise.

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