Joe,
He does talk about cells, but I believe that he gives you enough information
to work out how to achieve your objective. The important point about Chip's
article is that he covers all of the things you need to consider, and gives
you a download to play with.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Joe 90" (remove silly spam) wrote in message
...
Hi Bob

I'll have a play with this, but Chip's solution only seems to apply to
positioning forms with cells. If my form, which is modeless, is open
infront
of a chart, I'll have to work on the position option for that too? I guess
its all there, just have to work at it!! Thanks for your help.

Joe

"Bob Phillips" wrote in message
...
Joe,

This might be of help http://www.cpearson.com/excel/FormPosition.htm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Joe 90" (remove silly spam) wrote in message
...
Hi

Have a little form I use as a popup to take user back to main worksheet.
My
dev env is running at 1024x768, but users run at 800x600.

the top and left properties work from top and left, so only ever give a
relative position from top and left. So if the resolution goes down, the
form vanishes off to the right!

I don't want the popup to obscure the data/charts I am using, how can I
make
it always go to a top right position, or even better inside the excel
window
(below the toolbars and to the left of the vertical scroll bar).

Regards

Joe