Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 12-09-2021, 03:38 PM
Guessed's Avatar
Guessed Guessed is offline Need a macro adjustment Windows 10 Need a macro adjustment Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Does this one solve the allow autofit issue?
Code:
Sub TablesResizeAll()
  Dim oTbl As Table
  For Each oTbl In ActiveDocument.Tables
    If Not oTbl.Rows.WrapAroundText Then
      oTbl.AllowAutoFit = False
      oTbl.AutoFitBehavior wdAutoFitFixed
      oTbl.PreferredWidthType = wdPreferredWidthPoints
      oTbl.PreferredWidth = InchesToPoints(7.2)
      oTbl.Rows.Alignment = wdAlignRowLeft
      oTbl.Rows.LeftIndent = InchesToPoints(0.3)
    End If
  Next oTbl
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need a macro adjustment Macro adjustment needed Ulodesk Word VBA 2 02-06-2020 06:49 AM
IF Statement Adjustment shawn.low@cox.net Mail Merge 0 09-23-2019 10:08 AM
Can I disable auto adjustment of sizes in Smart art Hierarchy charts? frankgoldman PowerPoint 1 05-04-2019 04:37 AM
Need a macro adjustment Automatic adjustment date zbiku25 Project 3 02-28-2017 09:03 AM
Need a macro adjustment Table adjustment on Surface OneNote TheMax OneNote 1 01-23-2015 04:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:12 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft