Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comment Automargins property
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get Property value of class instance by passing string property name | Excel Programming | |||
Excel Macro to enter same text in comment box file's property box of 132 different files | Excel Programming | |||
Runtime error 380 - Could not set the list property. Invalid property value. | Excel Programming | |||
Runtime Error 380 – Could not set the list property. Invalid property value | Excel Programming | |||
Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming |