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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Unprotecting worksheets 2
Cell Protection Query 15
security - protecting a worksheet 2
How do I turn scroll lock off (2007 excel)? No scroll lock key 1
Workbook protection 1
Protecting a Sheet 7
form buttons on sheet collapse on unhide - sometimes 5

Back
Top