![]() |
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