Protecting worksheet but allowing "forms" button to still call a macro

Hi,

I have a worksheet of data. I have two form-control buttons on this worksheet and each button executes a different macro.

One button protects the sheet so no one can alter it.
The other button unprotects the sheet.

THe problem is once i protect the sheet i cant click the other button.

Thoughts? Ideas?

never mind......the code was actually working......ie....i protected sheet and i was able to press the other button i just could not tell until i put something to the screen.......so sorry

Originally Posted by welchs101

never mind......the code was actually working......ie....i protected sheet and i was able to press the other button i just could not tell until i put something to the screen.......so sorry

you could share an example of the code or even a basic workbook so that others reading post could gain from your experience (me included sounds like a very useful ability)