+ Reply to Thread
Results 1 to 4 of 4

VBA-How to program sizing and placing Excel window at the start of the program

  1. #1
    Registered User
    Join Date
    07-18-2012
    Location
    Mysore
    MS-Off Ver
    Excel 2003
    Posts
    4

    VBA-How to program sizing and placing Excel window at the start of the program

    VBA-How to program sizing and placing Excel window at the start of the program

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: VBA-How to program sizing and placing Excel window at the start of the program

    I am not exactly clear of your requirement. What exactly do you require?

    If you require the Window to Autofit your Screen Size, just enter the range selection in the VBA code if not dynamic, and put ActiveWindow.Zoom = True

    Hope it helps.

    Deep
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    07-18-2012
    Location
    Mysore
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: VBA-How to program sizing and placing Excel window at the start of the program

    I have written a VBA program to use form and the excel window should hide behind the form

  4. #4
    Registered User
    Join Date
    07-18-2012
    Location
    Mysore
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: VBA-How to program sizing and placing Excel window at the start of the program

    Further, I have written VBA Program to fire other 4 user forms located in other excel work books, from Master user form. But when I exit from other forms, it fails to go back to Master user form. I am now using a technique to fire the master user form fresh by selecting another sheet in the Master excel work book. I wish to use one additional command button continue in other forms which should bring back my control to master user form. Please help.

+ 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 to alternate window based program macro ...
    By H-Man3 in forum Excel General
    Replies: 0
    Last Post: 02-09-2012, 09:36 AM
  2. Replies: 4
    Last Post: 02-09-2012, 09:29 AM
  3. Replies: 0
    Last Post: 01-16-2012, 02:45 PM
  4. How to start the default mail program using Excel VBA?
    By Michalakis Michael in forum Excel General
    Replies: 2
    Last Post: 06-09-2005, 09:05 PM
  5. VBA program to simulate Watch Window in Excel 2000
    By arthurmacarthur in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2005, 12:04 PM

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