close

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

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

quot;Conditional Formattingquot; wrote:

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

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()

E-mail轉寄