Hi expert,
For instance if I create a new window using the macro, how can I set the postition and size of the new window?
Best Regards
lizaro
Hi expert,
For instance if I create a new window using the macro, how can I set the postition and size of the new window?
Best Regards
lizaro
Last edited by VBA Noob; 05-04-2008 at 07:24 AM.
Turn on the recorder and record your actions of adding the new workbook and resizing it
http://www.bettersolutions.com/excel...C420921011.htm
Then amend as required
Example below
VBA Noob![]()
Please Login or Register to view this content.
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
This is our second question that i have seen where you give only a brief outline of your question. If you want help you must give a more detailed explanation of what you are doing.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks