Disable Command Bars

  • Thread starter Thread starter Danny
  • Start date Start date
D

Danny

Is there a command to disable ALL command bars with out
naming them one by one, i.e.:

Application.CommandBars("Standard").Enabled = False

Also, how can I disable ANY "personal/custom" bar?

When I lend my spreadsheets, the user can still use
his/her custom command bar even if I disabled all the
command bars (namaing them one by one in the macro).

Thanks
 
Back
Top