Protecting choice buttons

M

MNR Lady

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
 
D

Dave Peterson

Maybe just protecting the objects would be sufficient:

Something like this in code:

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