Enabling Multiple buttons

[TheNoocH]

i have code like this that disables all my command buttons except the one named cmdReset (and it works fine)

      For Each ctl In Main.Controls
           If TypeOf ctl Is MSForms.CommandButton Then
              If ctl.Name <> "cmdReset" Then
                ctl.Enabled = False
              End If
           End If
      Next ctl

what if i want to skip more than just "cmdReset"?

eg i tried

if ctl.name <> "cmdReset" or ctl.name <> "cmdExit" Then

but that seems to disable ALL command buttons including cmdReset and cmdExit...

any thoughts?

 

[Andrew Poulsom]

Shouldn't it be?

If ctl.Name <> "cmdReset" And ctl.Name <> "cmdExit" Then

 

[TheNoocH]

my bad...i actually did try that first...

i had a dumb mistake...i had cmdExit and I forgot I renamed it to cmdMainExit....

thanks...it helped....