locked cell issue
i have some cells i have unlocked.
when i protect the worksheet, i can clear the unlocked cells i can put values in the unlocked cells but when i try to set the numberformat, it fails, "unable to set the format property of the range class". ..NumberFormat = "#,##0.00" unprotect the sheet, it works fine. and i know it's accessing the unlocked cell, because if i step through, i can see the format change. -- Gary |
locked cell issue
You can only enter or delete data in the unlocked cells of a protected sheet.
You cannot change the settings without unprotecting. The protection is to prevent that type of change without the owner's knowledge. "Gary Keramidas" wrote: i have some cells i have unlocked. when i protect the worksheet, i can clear the unlocked cells i can put values in the unlocked cells but when i try to set the numberformat, it fails, "unable to set the format property of the range class". ..NumberFormat = "#,##0.00" unprotect the sheet, it works fine. and i know it's accessing the unlocked cell, because if i step through, i can see the format change. -- Gary |
All times are GMT +1. The time now is 05:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com