ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   AutoShape Location (https://www.excelbanter.com/excel-programming/377572-autoshape-location.html)

Ronbo

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.


All times are GMT +1. The time now is 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com