harilalmn Posted March 17, 2011 Posted March 17, 2011 Hello All, Wow...!! It is really great to have this site back after maintenance..!! I was craving for it...!!! Well... I have a small problem. How to Clear Font Override Inside Cells of a Table using VBA? Assume I have a table which has same cell style and text style for all the cells of a table, but with different fonts in different cells. So evenif I change the cellstyle or text style of a cell, it doesn't make any change..!! I tried the lisp StripMText and all.... But it worked for some tables only. I have to edit this in more than 600 tables from 60 files..!!! Is there anyway I can access the 'Font' property of a cell through VBA? Quote
fixo Posted March 17, 2011 Posted March 17, 2011 You might be want to look at his thread You have to create cell styles as many as you need using code written by Andrey from there: http://www.theswamp.org/index.php?topic=34217.msg395614 then you could be change the newly created cell styles manually and set the different text properties for these styles Then just apply them to your cells ~'J'~ Quote
harilalmn Posted March 18, 2011 Author Posted March 18, 2011 Great suggestion fixo..., but, the problem is that various cell styles are already existing. Each table has its cells assigned with a particular cell style. But the Font inside the cell has been a mess. For the same table, say, cell A1 and B3 have the same cell style assigned. But, the one has font Arial in it and another has Calibiri, where the cell style has RomanS. I think changing the cell style doesn't change the font of the cell, unless the cell has the same font as that of the cell style. Is it not so? Quote
fixo Posted March 18, 2011 Posted March 18, 2011 Another idea is using mtext formatting to overrwrite cell font You could be recreate cell text using it I think Not tested, just from the top of my head Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.