LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 866
Default Moving a shape with text inside without editing text

I am working on a project in Excel. I need to generate a shape, place text
inside that shape, and then allow the user to drag that shape around on the
sheet.

I have not been successful adding a shape, then using the TextFrame property
to add the text. Also have tried placing a text box.

If there is a way to "lock" the text so that it cannot be edited, maybe that
would work, but I can't find a way to do that.
Or, if there is a way to maybe add another shape on top of the text, and
group the text box to the shape, so that selecting the group and dragging has
the desired effect.

Can this be done? There must be a trick out there somewhere!

Thanks in advance.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
searching for text inside a text box wildetudor Excel Discussion (Misc queries) 0 January 21st 09 02:16 PM
How to embed large number of variables in text inside a text box? Riva Chase Excel Discussion (Misc queries) 0 October 30th 07 01:42 AM
Cutting and pasting large variable text into a text box shape usin AJL Excel Programming 0 October 30th 06 06:54 PM
How to make the text inside Text Box upside down? Kataro Excel Discussion (Misc queries) 1 December 21st 05 03:38 PM
Editing text in text box grouped within a trapezoid Linking to specific cells in pivot table Excel Programming 11 August 16th 05 09:17 AM


All times are GMT +1. The time now is 02:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"