I really hope someone can help me with the following issue.
I finally have the merged cells resizing the way I need, however it seems to lock the cell after the process not allowing it to be edited again until I unlock the sheet. below is the current code I am using
If anyone has ideas of what I am missing I would greatly appreciate the help.
Please Login or Register to view this content.
Last edited by Leith Ross; 05-17-2014 at 09:42 PM. Reason: Added Code Tags
Hello wvvvdracovvvw,
Welcome to the Forum!
Just unlock each cell in the merged area...
Please Login or Register to view this content.
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!)
Not getting it to work still. Attached is the worksheet. The password to unprotect the sheet is "trial"Shift Report Trial3.xlsm
Hello wvvvdracovvvw,
Try this out...
Please Login or Register to view this content.
Still did not work, but I see what you were trying to have it do. I tried moving the unlock function to the last part, and it seems to be running great.
Ended up with the following code
Please Login or Register to view this content.
Thank you very much for the help, I know this would have taken me forever to find a solution without your help.
Last edited by Leith Ross; 05-17-2014 at 11:44 PM. Reason: Added Code Tags
Hello wvvvdracovvvw,
You're welcome. Good thinking on moving the unlock portion of the code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks