Alle besturingselementen zijn van de ActiveX-reeks.
Ik probeer de rode regels uit onderstaande code te vervangen door 1 regel.
Met volgende code:
Dit werkt echter niet.
Wie weet de oplossing?
Ik probeer de rode regels uit onderstaande code te vervangen door 1 regel.
Code:
Sub Begin()
[COLOR="#FF0000"]Sheets(1).OptionButton1.Enabled = True
Sheets(1).OptionButton2.Enabled = True
Sheets(1).OptionButton3.Enabled = True
Sheets(1).ComboBox1.Enabled = True
Sheets(1).CommandButton1.Enabled = True
Sheets(1).CommandButton2.Enabled = True
Sheets(1).CommandButton3.Enabled = True
Sheets(1).CommandButton4.Enabled = True[/COLOR]
ActiveWindow.DisplayWorkbookTabs = True
Sheets(1).Unprotect "neil"
Sheets(2).Unprotect "neil"
End Sub
Code:
Sub Begin()
Sheets(1).OLEObjects("OptionButton1", "OptionButton2", "OptionButton3", _
"ComboBox1", "CommandButton1", "CommandButton2", "CommandButton3", "CommandButton4").Object.Enabled = True
ActiveWindow.DisplayWorkbookTabs = True
Sheets(1).Unprotect "neil"
Sheets(2).Unprotect "neil"
End Sub
Wie weet de oplossing?