Thread: [Solved] VBA to set Content controls as non printing
View Single Post
 
Old 01-12-2021, 04:37 PM
gmaxey gmaxey is offline Windows 10 Office 2016
Expert
  
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,429
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default
Replace that single Declare Sub Line with:

#If VBA7 And Win64 Then
Private Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
#Else
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
#End If
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote