View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Trevor Williams Trevor Williams is offline
external usenet poster
 
Posts: 181
Default 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