ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Protect Sheet with Marcro (https://www.excelbanter.com/excel-worksheet-functions/61510-protect-sheet-marcro.html)

Conditional Formatting

Protect Sheet with Marcro
 
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

Protect Sheet with Marcro
 
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



All times are GMT +1. The time now is 03:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com