View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ronbo Ronbo is offline
external usenet poster
 
Posts: 162
Default AutoShape Location

I have a large worksheet broken into pages/screen. Each screen has a button
that creates a call out. The code I have (for one location) is;

ActiveSheet.Shapes.AddShape(msoShapeLineCallout2, 750#, 400#, 72#, 48#). _
Select

This is an absolute reference (750#, 400#) to one page/screen. I do not
want to write code for each button. I need a macro that will call up a call
out and locate it in the center of the page/screen I am viewing.

Thanks a lot for any help.