PC Review


Reply
Thread Tools Rate Thread

AutoShape Location

 
 
=?Utf-8?B?Um9uYm8=?=
Guest
Posts: n/a
 
      17th Nov 2006
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.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format Autoshape box pops up on screen when autoshape is selected MaddyP Microsoft Powerpoint 0 28th Oct 2009 05:12 PM
Draw/Change Autoshape to custom autoshape for a comment Matthew Schwarz Microsoft Excel Discussion 0 11th Oct 2009 06:17 AM
Use mouse location to place autoshape via VBA ker_01 Microsoft Excel Programming 0 16th Sep 2009 07:21 PM
Automatically change autoshape color to that of another autoshape T-bone Microsoft Excel Programming 2 24th Oct 2008 01:43 AM
trigger not working on autoshape which is under another autoshape with text Bob Microsoft Powerpoint 2 20th Apr 2004 12:26 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:52 PM.