Protecting choice buttons

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created these great choice buttons but now I want to lock them so users can't accidentally delete/move/edit them. If I lock and protect them, nobody can click on them. Any suggestions?

Thanks,
TW
 
Maybe just protecting the objects would be sufficient:

Something like this in code:

ActiveSheet.Protect DrawingObjects:=True, Contents:=False, Scenarios:=True
 
Back
Top