Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AutoShape | Excel Discussion (Misc queries) | |||
Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
autoshape | Excel Discussion (Misc queries) | |||
Mouse Location, Movement and Spreadsheet Location | Excel Programming | |||
autoshape | Excel Programming |