Hi Guys,
I'm seeking some assistance in trying to merge several sheets in a workbook. The problem i'm experiencing is that because the workbook is shared and protected, I do not have the ability to utilize VBA. I also tried to use the add on Kutools. Not sure if you have heard of it, but it doesn't seem to work once the workbook is shared and protected. It seems to be a case of one or the other. I either have to do away with the shared and protected option to be able to merge or keep my shared and protect and forget the merge. Anyone know of another way I can work around that feature ?
I'm seeking some assistance in trying to merge several sheets in a workbook. The problem i'm experiencing is that because the workbook is shared and protected, I do not have the ability to utilize VBA. I also tried to use the add on Kutools. Not sure if you have heard of it, but it doesn't seem to work once the workbook is shared and protected. It seems to be a case of one or the other. I either have to do away with the shared and protected option to be able to merge or keep my shared and protect and forget the merge. Anyone know of another way I can work around that feature ?
