See in this VBA where it says,
I need this to be changed in my sheet, in column "C" to show the contents of whatever text notes get typed in by my project managers and also the next row, then the next, etc. I guess you call that a "dynamic range"? not sure. I did creat all the sheets in the workbook and love, LOVE excel! I am darn near obsessed with excel and think it should be used for everything. . I am still very novice with it though and it takes quite awhile to put some of those sheets together and get them to behave properly. I have never messed with VBA. Completely foreign to me, but see that it is very powerful. I will be learning how to use it though. Very Cool stuff.
You are obviously "the Man" when it comes to writing this stuff. Very Impressive.
thanks again for your help. I am so excited to have you on this workbook. I know you are going to notice the rows showing are like 362 or so and not rows 3,4,5, etc. That's because I had to hide them because they would lock after entry and I couldn't delete them. That vba for auto-locking is exactly what I need so no one can go back and alter the notes without password or admin. rights but as I have been messing around with it to try to make it work properly, I have created a real mess. I don't know how to get it back to the first rows and set the range of active rows from the top of the sheet starting with row 3 and going down to at least 200 rows or the whole sheet if that is easier. Sorry for the mess I made of the Sheet "Communication Log". If you need to start a new sheet from scratch, I understand. I can just ad the info. for Representative, Customer, date, etc. easy enough. Thanks again for your help.
Bookmarks