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
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
I have written a VBA program to use form and the excel window should hide behind the form
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks