+ Reply to Thread
Results 1 to 6 of 6

save with a predetermined view size

  1. #1
    Registered User
    Join Date
    01-31-2012
    Location
    Australia
    MS-Off Ver
    OFFICE 365
    Posts
    31

    save with a predetermined view size

    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

  2. #2
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: save with a predetermined view size

    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.
    Good luck.

  3. #3
    Registered User
    Join Date
    01-31-2012
    Location
    Australia
    MS-Off Ver
    OFFICE 365
    Posts
    31

    Re: save with a predetermined view size

    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%.

  4. #4
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: save with a predetermined view size

    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.

  5. #5
    Registered User
    Join Date
    01-31-2012
    Location
    Australia
    MS-Off Ver
    OFFICE 365
    Posts
    31

    Re: save with a predetermined view size

    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

  6. #6
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: save with a predetermined view size

    My pleasure, Paul.

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1