I have a quite a few worksheets (let us say Sheet1, Sheet2, Sheet3) in my workbook, each with individual levels of zoom.
I have the following code that can set zoom levels for individual worksheets each time a worksheet is accessed:
However, the problem (as with all macros) is that the above code disables the undo function in case I change back and forth from individual sheets, since it is run every time I access a sheet.
Following macro sets a default zoom level for all worksheets at the time of opening the workbook:
But this second code sets a single zoom level for all workbooks.
I was wondering how to combine these 2 codes to set customised zoom level to each of the worksheets (Sheet1, Sheet2, Sheet3). But I wish to set this ONLY at the time of opening the workbook and not afterwards. In other words, can I point the zoom level for each worksheet at the time of workbook open?