Centering In Screen

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

screen update 17
How can I use Shapes in 2007? 3
On Action 1
How do I name an autoshape so that I can refer to it in a macro? 3
ActiveSheet.Shapes("Rectangle 23").Select will not work in 2007 3
Text in a Rectangle Object 2
Changing color of a shape 1
Create a simogram in Excel using rectangles 0

Back
Top