Ohh dear no replies.

Looks like I cannot set the position of dialogue boxes
and I will have to think again.



-----Original Message-----

Hi there,

I have used this newsgroup a number of times now, and
people have always been very helpful.

My next question, :)

I have a macro which opens up a Data / Form dialogue box
on a different sheet to where the macro is called from.

The macro is a user input form and I have used a
different sheet so I can display instructions for the
user to refer to.

When the dialogue box opens, its initial position seems
random. I need it to display in the top-center of the
sheet so I can wrap guidance around it.

I can position the box myself, and then when I close it
and call it again from the macro, it remembers that
position, but it is the initial call when the
spreadsheet
is opened which fails to position it where I need it.

I could give the users guidance how to position it but
would rather not.

Is there any way I can force an absolute display
position
when I call it?

Many thanks in advance.

Mark Flaxman

.