Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 02-22-2018, 08:33 PM
macropod's Avatar
macropod macropod is offline Reset content controls in specific row. Windows 7 64bit Reset content controls in specific row. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,520
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try:
Code:
Sub DeleteOneRow()
Application.ScreenUpdating = False
Dim lProt As Long, CCtrl As ContentControl: Const StrPwd As String = ""
'Ensure we're within the row 3 or higher in the 2nd table
With Selection
  If .Information(wdWithInTable) = False Then Exit Sub
  If ActiveDocument.Range(0, .Range.End).Tables.Count <> 2 Then Exit Sub
  If .Cells(1).RowIndex < 3 Then Exit Sub
End With
'Delete the selected row
With ActiveDocument
  lProt = .ProtectionType
  If lProt <> wdNoProtection Then .Unprotect Password:=StrPwd
  With .Tables(2).Rows(Selection.Cells(1).RowIndex)
    For Each CCtrl In .Range.ContentControls
      CCtrl.LockContentControl = False
    Next
    .Delete
  End With
  If lProt <> wdNoProtection Then .Protect Type:=lProt, Password:=StrPwd 
End With
Application.ScreenUpdating = True
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Reset content controls in specific row. Listbox Content Control - Reset default/prompt? ArtKilp Word VBA 7 08-08-2017 05:31 PM
Reset content controls in specific row. Problems Copy table content and reset contentControls h0mebrewer Word VBA 1 12-14-2016 05:37 PM
Macro to save docx to doc that checks compatibility and converts content controls to static content. staicumihai Word VBA 4 10-12-2016 08:23 PM
VBA for content controls ciresuark Word VBA 1 03-10-2015 03:14 PM
Reset content controls in specific row. Content Controls Sammie0Sue Word 6 11-06-2013 10:56 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:15 AM.


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