+ Reply to Thread
Results 1 to 5 of 5

Workbook reduced in size after a crash, now wont go back to normal size.. :(

  1. #1
    Registered User
    Join Date
    04-04-2013
    Location
    Darwin Australia
    MS-Off Ver
    Excel 2010
    Posts
    36

    Workbook reduced in size after a crash, now wont go back to normal size.. :(

    Im usually ok with these sort of problems but after MSoffice crashed today, for some reason the workbook i was using reduced in size and i can not no matter how i try get it back to normal screen size.
    I am sure its something very simple but some reason I can not fix it.. it will not drag or alter in size at all....

    Someone must have a suggestion for me.. please see jpeg

    Thank you
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Workbook reduced in size after a crash, now wont go back to normal size.. :(

    As a stop gap measure try putting this into a code module..

    Please Login or Register  to view this content.
    Elegant Simplicity............. Not Always

  3. #3
    Registered User
    Join Date
    04-04-2013
    Location
    Darwin Australia
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Workbook reduced in size after a crash, now wont go back to normal size.. :(

    Hi Andy, thanks for your rely, I already have a macro code in module1, I tried putting the code in a new module (2), but no change, am I correct by inserting this code into a new module. Thanks

  4. #4
    Registered User
    Join Date
    04-04-2013
    Location
    Darwin Australia
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Workbook reduced in size after a crash, now wont go back to normal size.. :(

    Andy, I have accidentally fixed it, some reason the workbook was locked, after i unlocked it the workbook opened up to normal size, I am sure that shouldnt have happened, unless it was the code that you gave me helped, will monitor it with and without your code, anyway thanks again

    Cheers

    Craig

  5. #5
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Workbook reduced in size after a crash, now wont go back to normal size.. :(

    Glad you're sorted Craig..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 : Calendar size wont stay!
    By Marz73 in forum Excel General
    Replies: 2
    Last Post: 12-03-2011, 03:20 AM
  2. Saved file size not reduced to original
    By rustleg in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-29-2009, 07:32 PM
  3. Excel file size reduced?
    By xIcarus in forum Excel General
    Replies: 2
    Last Post: 10-01-2007, 07:20 PM
  4. [SOLVED] wont print in legal size
    By Joe_Berg_WorldTrade in forum Excel General
    Replies: 1
    Last Post: 11-09-2005, 08:30 PM
  5. Workbook page is not normal size
    By Arden in forum Excel General
    Replies: 1
    Last Post: 06-29-2005, 09:05 PM

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