My code works but not in shared mode. I have searched for answers and tried many suggestions but can't manage to get an answer so thought I would join a forum and give it a try. Basically, I use a form to ask for a name and search all the sheets for that name and copy a few cells to a new sheet for a report or case list. The first column on each sheet is a case number that links to the case file folder. The links are added out of shared mode due to shared mode restrictions. I just want to copy pre-exsiting links to a new sheet. The line in the ELSE section copies everything over in shared mode but you cannot follow the link hense why I thought to seperate lines with a link and without. Any Ideas or help much appreciated. Please see my Find cases code below.
Moderators note: code tags added for you - this timePlease Login or Register to view this content.
Bookmarks