save with a predetermined view size

[pvwebster]

I have a shared spreadsheet that when others exit is saved with differing view sizes (i.e. 65%, 70%). I want to set up a macro (or something else) that will automatically save at 85% when it saves and exits. Is this at all possible? Any help would be very much appreciated.

Paul

[OnErrorGoto0]

The zoom settings are sheet specific, so you would need to use say the BeforeSave event of the workbook to loop through each sheet, activate it and set the zoom for the window as required.

[pvwebster]

Thanks for your quick reply OEGO. I am pretty much a novice with these macros and am not sure how to start this canypu please give me an example. For example my workbook is called 'schedule_2012' and I have 12 sheets, one for each month - jan, feb, mar etc... What I want to do is stop people saving at different zoom sizes and have the book automatically save all sheets at a default size of 85%.

[OnErrorGoto0]

Open the VB Editor, locate your workbook in the Project Explorer window (top left) and then double-click on the ThisWorkbook object and paste this code into the main code window

Please Login or Register  to view this content.

[pvwebster]

0EGO, thank you so much for this, it works a treat. looking at the code I would never have been able to do it. This has now ended months of annoyance and makes things just that bit easier for me. Again thank you for your help it is really appreciated.

Kind regards
Paul

[OnErrorGoto0]

My pleasure, Paul.

Please do not forget to mark the thread Solved. (See FAQ at top of the page)