+ Reply to Thread
Results 1 to 5 of 5

resize active window ie: add to the height of the active window

  1. #1
    Registered User
    Join Date
    10-25-2013
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    79

    resize active window ie: add to the height of the active window

    hi i was just wondering if it possible to create a macro that permanently increases the height of a workbook by a set increment

    i have several workbooks that i have the code below assigned to
    Please Login or Register  to view this content.
    so when they open they resize to that set size and position. and what ive been doing if i need to resize (which is often) is just adjust the values in the above code.

    not that the way ive been doing it is difficult but i was thinking how great it would be if i could have a macro i could run that permanently adds 9 to the .Height and subtracts 9 from the .Top

    dont know if its possible so if anyone has an idea that would be great

    thanks

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: resize active window ie: add to the height of the active window

    Try
    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Registered User
    Join Date
    10-25-2013
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    79

    Re: resize active window ie: add to the height of the active window

    that works temporarily, but if i minimize or close and open it again it goes back to the original size because of the code i have attached to it

    i almost need a macro that goes into vbe and changes the code, and i dont know if that is possible

    thanks

  4. #4
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: resize active window ie: add to the height of the active window

    It might be easier if that code were called by a sub (?button?) rather than in the Activate event.
    Let the workbook appear the same size as you left it, but go to your predetermined size when you press a button.

  5. #5
    Registered User
    Join Date
    10-25-2013
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    79

    Re: resize active window ie: add to the height of the active window

    hmm not really, i usually have them minimized and mostly recall them via a hyperlink, and when i do that they get resized way too small as the sheet with the hyperlink is small, so i need them to be resized on activating.

    thanks

+ 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. How to know what the active window is?
    By keymuu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2013, 10:39 AM
  2. SendKeys in Active Window
    By roki4 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2012, 03:35 PM
  3. need help in making the current window as active window.
    By ashvija in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-27-2012, 06:04 PM
  4. [SOLVED] VBA Set MS Word as the active window
    By Gaz_m2k5 in forum Excel General
    Replies: 0
    Last Post: 06-25-2012, 08:36 AM
  5. active window
    By khalid79m in forum Excel General
    Replies: 2
    Last Post: 01-05-2007, 11:36 AM

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