Quote:
Originally Posted by Gizzmo
Will have a look at it later as I am at work at the moment. Also can I ask why you specifically want it in the Comments v a seperate log? I am not an expert but I suspect that the comments box will have a limit to the number of characters, so I am worried you will reach this limit. Also adding comments to every cell will increase your file size etc.
|
I expect cell value to be changing no more than 4 times so hopefully character limit won't be a problem. I agree that a separate log genrally makes makes much more sense but it also means that you'll have to go to a different tab where you'd keep it. With the total number of those rows and columns where I need date stamp it will be a nightmare to switch back and forth, whereas having date stamp and user in the comments will make it possible to dynamically check it without leaving the worksheet.
Thank you for looking into this,
Art
Similar Threads
Threaded Mode
