ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   adding and removing style properties (https://www.excelbanter.com/excel-programming/282806-adding-removing-style-properties.html)

jmeg[_2_]

adding and removing style properties
 

Hello,

I have successfully created styles from VB to excel...But...

When I use my new style(s) in excel, it overrides previous formattin
in the spreadsheet. Is there a way I can control or set the new styl
values to nil or uncheck the properties in the style dialog box s
previous formatting (color, font size etc) remains but the style nam
changes?

thank you very much for your help.



-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com


jmeg[_3_]

adding and removing style properties
 

^up. thanks

To clear things up, I just need my new styles that I create to no
override any other colors or fonts on a preexisting document if used.

thanks again.
Jaso

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com



All times are GMT +1. The time now is 10:35 PM.

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