Start Up Position for Workbooks...
 

Is it possible to set the start up position of a workbook the same way as a
UserForm - I'm looking to position a workbook (which has Protect Workbook
Window switched on) as CenterOwner (or equivalent).

Thanks

Trevor

Start Up Position for Workbooks...
 

You would have to calculate it yourself from:
Application.UsableHeight/Width
ThisWorkbook.Windows(1).Height/Width
Unprotect the WB, so you can change the Window properties.
Then move the window appropriately.

NickHK

"Trevor Williams" wrote in
message ...
Is it possible to set the start up position of a workbook the same way as
a
UserForm - I'm looking to position a workbook (which has Protect Workbook
Window switched on) as CenterOwner (or equivalent).

Thanks

Trevor

Start Up Position for Workbooks...
 

Cheers Nick - I had a feeling it was something along those lines - shame it's
not built in!

I'll give it a go.

Trevor

"NickHK" wrote:

You would have to calculate it yourself from:
Application.UsableHeight/Width
ThisWorkbook.Windows(1).Height/Width
Unprotect the WB, so you can change the Window properties.
Then move the window appropriately.

NickHK

"Trevor Williams" wrote in
message ...
Is it possible to set the start up position of a workbook the same way as
a
UserForm - I'm looking to position a workbook (which has Protect Workbook
Window switched on) as CenterOwner (or equivalent).

Thanks

Trevor