Protecting and Unprotecting an Excel Sheet

[Ascentient]

I have a simple Excel spreadsheet that contains 10 comboboxes. In the Change Event, I test the value to find out what cells will be copied and pasted into another portion of the worksheet.

The "people" using this sheet would like to proctect the sheet, but doing so kills the copy and paste code I have in the Change Event.

My question to you all, is there a way to unprotect the sheet, do my Change event code and then protect it again? If so, what code do I need or where can I find the reference material so I can learn and put the code into place.

Ascent.

 

[PHV]

Have a look at the Protect method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Ascentient]

Thanks PHV, that worked like a champ!

Do you know if there is a way to change the message that pops up when they try to modify a protected cell?

Ascent