<div>
Thanks Shanan!<br />
<br />
Seamus
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I work of two screens.<br />
<br />
if excel is open on one screen adn i open a particular WB with a userform, the userform pops up on the other screen. How can i change the properties/behaviour so that it opens where the WB is and in the centre ofthe screen<br />
<br />
Thanks<br />
Seamus
</div>
</div>


Hi,

I work of two screens.

if excel is open on one screen adn i open a particular WB with a userform, the userform pops up on the other screen. How can i change the properties/behaviour so that it opens where the WB is and in the centre ofthe screen

Thanks
Seamus

User  Form Initialize behaviour

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.