Comment Automargins property

Guest

Posts: n/a

17th Jan 2008

Hi,

I'm trying to write code to change a comments margins:

Selection.ShapeRange.TextFrame.MarginLeft = 7.09

For the effects to take effect however you have to turn off the automargin
property. You can do this manually (unchecking the checkbox in the Format
Textbox dialog) but there doesn't seem to be a way to do this
programmatically(?).

Selection.ShapeRange.TextFrame.AutoMargins = False raises an error.

Regards
Pete

« Another runtime 1004 error | Can't save any more in Excel 2007 Compatibility Mode »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Macro to enter same text in comment box file's property box of 132 different files	Kat	Microsoft Excel Programming	19	29th May 2007 07:01 AM
Tag Property for ListBox Items - This is a Comment	=?Utf-8?B?RGVubmlz?=	Microsoft VB .NET	0	9th Sep 2005 10:37 PM
How do you change the NTFS File Comment property of a file?	TJ	Windows XP Help	5	27th Feb 2005 05:17 PM
Accessing File Property - "Comment"	=?Utf-8?B?Qks=?=	Microsoft VB .NET	4	9th Feb 2005 04:47 PM
Write to a File's Comment property	Greg	Microsoft Access VBA Modules	2	21st Jan 2004 07:31 PM