Protect Sheet with Marcro

[Conditional Formatting]

I have created a user form and the database will be in Sheet1. I'm trying to
protect the sheet but when i protect it the macro does not working.

Thanks

[William Horton]

You can have the macro unprotect the sheet, do what it needs to do, and then
re-protect the sheet when it's done.

Hope this helps.

Thanks,
Bill Horton

"Conditional Formatting" wrote:

> I have created a user form and the database will be in Sheet1. I'm trying to
> protect the sheet but when i protect it the macro does not working.
>
> Thanks