![]() |
How do set/ fix the opening position of a user form
I have a 2007 Excel macro which displays a user form for input. I want the
user form to always be located over cells A1:D6 of the worksheet when it is opened by the macro, regardless of the Excel window size and/or Excel window location, how can this be done? (the issue I am encountering is when users have multiple screens displaying data and Excel is being displayed on (for example) screen two, the user form opens and positions itself in the upper left corner of the left most screen and users cannot find the userform). |
All times are GMT +1. The time now is 07:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com