ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Textbox margin overwritten by auto-margin (https://www.excelbanter.com/excel-programming/326564-textbox-margin-overwritten-auto-margin.html)

Jess

Textbox margin overwritten by auto-margin
 
We have a textbox that is added in vba, and when we try to set the margin in
the vba code the auto-margin settings keep over-writing the settings in our
code. Here is how we are adding the textbox:

ActiveSheet.Shapes.AddTextbox(msoTextOrientationHo rizontal, 281, 23.75, _
260, 25).Select
Selection.?????????

Does anyone know a way to prevent the auto-margin settings from taking over?

Thanks!


All times are GMT +1. The time now is 03:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com