Hi,
As a non VBA person I am clueless so I'm back here again for more help from the people in the know. I have the code below (thanks to tehneXus for this) which removes the user name from all comments and retains the formatting (click here for thread). it does exactly as required after testing however when i applied this to real work it decided to give up after a few minutes because of the amount of comments throughout the worksheet.
As I will only use this every few weeks when the file in question is updated and the only the one column is edited each time so to stop the computer 'freezing up' on me at work I was hoping someone can help me modify the code so that it either A) runs through selected cells or B) runs though a column of choice on the active sheet. Option A would be preferable for ease but I don't mind using B instead even if I need to change the code each time to refer to the correct column.
Thanks to all for your help.Please Login or Register to view this content.
Bookmarks