Zoom Display for whole workbook
 

I have number of worksheets in the one workbook all currently sitting at zoom
127% - I want to konw if there is away I can changed the zoom display all on
sheets at once to 75%

Zoom Display for whole workbook
 

Hi,

Alt+F11 to open VB editor.
Double click this workbook and past this in on the right:-

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
ActiveWindow.Zoom = 75
End Sub

Mike

"Angie" wrote:

I have number of worksheets in the one workbook all currently sitting at zoom
127% - I want to konw if there is away I can changed the zoom display all on
sheets at once to 75%

Zoom Display for whole workbook
 

Angie, another way

Hold down the Ctrl key and click all the sheet tabs to select them and then
set your zoom.

Mike

"Angie" wrote:

I have number of worksheets in the one workbook all currently sitting at zoom
127% - I want to konw if there is away I can changed the zoom display all on
sheets at once to 75%

Zoom Display for whole workbook
 

Select one sheet then right-click and "select all sheets".

Set the zoom on the active sheet and will be done to all.

DO NOT FORGET to ungroup the sheets when done.


Gord Dibben MS Excel MVP

On Fri, 14 Sep 2007 01:12:02 -0700, Angie
wrote:

I have number of worksheets in the one workbook all currently sitting at zoom
127% - I want to konw if there is away I can changed the zoom display all on
sheets at once to 75%