protecting cells with macros
does anyone know how to protect (unprotected) cells with macros whil the sheet itself is protected? i'm running into run-time error (Unable to set the Locked propertyof the Range class '1004'). thanks! maly_paja ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
protecting cells with macros
Maly
I'm not sure what you want but normally the cells to be operated on are first unlocked on the Format Menu before the sheet is protected. If you need to unprotect the sheet during a macro you can use a toggle in the code. Protect = not proctect Record the Protecting and Unprotecting the macro then revise the code regards Peter Atherton -----Original Message----- does anyone know how to protect (unprotected) cells with macros while the sheet itself is protected? i'm running into run-time errors (Unable to set the Locked propertyof the Range class '1004'). thanks! maly_pajak ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ . |
protecting cells with macros
Hello Maly,
You need to unprotect your sheet first. Activesheet.Unprotect "PASSWORD" 'your code here Activesheet.Protect "PASSWORD" Replace "PASSWORD" with your password if there is any otherwise don't include that word. Regards, Jon-jon "maly_pajak" wrote in message ... does anyone know how to protect (unprotected) cells with macros while the sheet itself is protected? i'm running into run-time errors (Unable to set the Locked propertyof the Range class '1004'). thanks! maly_pajak ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
All times are GMT +1. The time now is 05:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com