LinkBack URL
About LinkBacks
Hi hektisk
Almost...right click on the sheet (Sheet1) based on your sample file...copy the code into the window on the right. The code DOES NOT go in a general module...it goes in the sheet module.
See attached.
Hi hektisk
Almost...right click on the sheet (Sheet1) based on your sample file...copy the code into the window on the right. The code DOES NOT go in a general module...it goes in the sheet module.
See attached.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
OK, prior to your post I had put the code both in the worksheet module and general module just in case, and but neither seemed to work. I opened the workbook you sent me, enabled macros, and every cell from b3:h13 are locked, no matter the data in a3:a13. I see the text you inputted in b7:b9, so I'm not sure what I'm doing wrong. Is there something else I need to do? Thank you again.
Originally Posted by jaslake
Hi hektisk
I'd be glad to help you debug this but I'm color blind...not kidding...remove the colors from your file and repost...can't "see" what's going on.
Ah! Sorry. Most of the colors were unnecessary, but I did use conditional formatting to fill the cells in b:h with a very dark green when the corresponding cell in column a was blank or said 'New Assessment (No DC)' - basically my first solution, until I realized I'd be better off with locking/unlocking as appropriate.
The colorless file is attached.
Last edited by hektisk; 02-08-2011 at 08:50 PM.
Hi hektisk
Ah...much better. Try the attached. I'm not certain where you're going with this. Let me know of issues.
Aha! It's working great now. Thank you so much!
One thing I'm noticing, however...since the sheet is now protected by default, new rows cannot be added to the table. It's vital that the table be expandable. I'm not sure if there's any way around this...unless if the worksheet ONLY becomes protected when one of the cells in b3:h13 (or beyond) is selected. Is this practical?
Hi hektisk
A new twist...how do you enter new rows? Do you type them directly into the table...another process?
Let me know...probably won't get back to you tonight...Super Bowl is over...got Grandson "off to school" duty in the AM...going to bed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks