Jump to content

Recommended Posts

Posted

Hello All,

:shock: 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..!!! :x

Is there anyway I can access the 'Font' property of a cell through VBA?

Posted

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'~

Posted

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?

Posted

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

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...