Hi,

I have a simple macro that create a rectangle with some text ("Working...")
that is displayed when I have any macro running to alert th user.
How do I get the rectangle in the centre of the the screen?

All help is appreciated.

J

ActiveWindow.VisibleRange

will give you the range that is visible. From this you should be able to
figure out what cell you want to position your rectangle over and consider
the size of the rectangle. If you can't figure it out, post back with some
details.

--
Regards,
Tom Ogilvy


"Jimbola" wrote in message
...
Hi,

I have a simple macro that create a rectangle with some text
("Working...")
that is displayed when I have any macro running to alert th user.
How do I get the rectangle in the centre of the the screen?

All help is appreciated.

J