![]() |
#2
|
||||
|
||||
![]()
To work with multiple content control checkboxes, you might use code like:
Code:
Private Sub Document_ContentControlOnExit(ByVal CCtrl As ContentControl, Cancel As Boolean) Dim StrNm As String Select Case CCtrl.Title Case "Check1": StrNm = "C:\Temp\MyWorkbook1.xls" Case "Check2": StrNm = "C:\Temp\MyWorkbook2.xls" Case "Check3": StrNm = "C:\Temp\MyWorkbook3.xls" Case "Check4": StrNm = "C:\Temp\MyWorkbook4.xls" Case Else: Exit Sub End Select Dim xlApp As New Excel.Application With xlApp .Visible = True .Workbooks.Open (StrNm) .Activate End With End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
checkbox, content control, vba |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
nolanthomas32 | Word VBA | 4 | 09-19-2017 06:25 AM |
![]() |
Deirdre Kelly | Word VBA | 23 | 09-07-2017 02:51 PM |
![]() |
wlcdo2 | Word VBA | 3 | 01-05-2017 05:52 PM |
![]() |
BrainSlugs83 | Word Tables | 8 | 11-14-2013 03:06 AM |
![]() |
creative cathy | Word Tables | 13 | 10-07-2012 08:52 PM |