+ Reply to Thread
Results 1 to 5 of 5

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

Hybrid View

  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
    Private Sub Workbook_Activate()
    '
    ' Macro2 Macro
    '
    
    '
       ActiveWindow.WindowState = xlNormal
        With ActiveWindow
            .Top = 175
        End With
        With ActiveWindow
            .Width = 510
            .Height = 322
        End With
    End Sub
    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
    With ActiveWindow
        .Height = .Height - 9
    End With
    _
    ...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