Hello All,
I use the following code below to let the user double click to get a "Check Mark" in a specified range of cells. However, when I try to protect the spreadsheet, this macro doesn't seem to run and gives me this error "Unable to set name properly of Font Class". Is there a work around to get this to work with the Spreadsheet protected?
Kindly help.
Booo
Please Login or Register to view this content.
Hello Booo,
You should unlock the cells in the range "MyChecks". It is a bad practice to lock or protect the cells a user needs to input data. All worksheet cells are by default "locked". You can select the cells in the range, right click, select Format Cells... > Protection (tab) > Locked (check box). Click the Locked check box to clear it and then save your changes.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I am not locking these cells. I am actually leting these be open but protecting the rest of the active spreadsheet. However, when I protect the spreadsheet, the code doesn't execute properly and gives me the error "Unable to set the name property of the Font Class"
Unless you deliberately unlocked the cells, they are locked.
You can only double-click in one cell, so there's no need to test for multiple cells.
Please Login or Register to view this content.
Last edited by shg; 12-15-2011 at 06:00 PM. Reason: lines out of order ...
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks