Turning “Allow spacing between cells” off with VBA ...

[Joe HM]

Hello -

I found a solution on how to uncheck the "Allow spacing between cells"
for tables via VBA in http://word.mvps.org/FAQS/MacrosVBA/TableSpacingOff.htm.
This talks about Word 2000 but it seems to also work with 2003.

I was wondering if there is a better solution for Word 2003? The
problem is if I go manually into the Table Properties... > Table >
Options... and then select the OK button, it will complain that the
Allow spacing between cells value is negative (-0.01).

Thanks,
Joe

 

[Joe HM]

Hello -

I found a solution on how to uncheck the "Allow spacing between cells"
for tables via VBA inhttp://word.mvps.org/FAQS/MacrosVBA/TableSpacingOff.htm.
This talks about Word 2000 but it seems to also work with 2003.

I was wondering if there is a better solution for Word 2003?  The
problem is if I go manually into the Table Properties... > Table >
Options... and then select the OK button, it will complain that the
Allow spacing between cells value is negative (-0.01).

Thanks,
Joe

Okay ... after some digging, I actually found a "clean" solution that
works in Word 2003 ...

With Dialogs(wdDialogTableTableOptions)
.AllowSpacing = 0
.Execute
End With

I guess I could have waited before posting but at least there is now a
solution in this group in case somebody else has the same question.

Prost!
Joe