Hello all
I have a central workbook used to collect data from more than one colleague. It has been set up to allow filtering to allow separate colleagues to filter their required data set. This has been set up using a custom toolbar with CommandBar drop down.
However the sheet is also protected so to allow the filtering to work it is unprotected filtered then reprotected. It works fine as an isolated workbook, but I have recently tried to share it to allow colleagues shared access. This has then thrown up errors in the code which arent their when its not shared.
Am I to understand that this is a problem created by the sharing and if so is it possible to share a protected workbook with these characteristics.
Many thanks in advance.
Neil
I have a central workbook used to collect data from more than one colleague. It has been set up to allow filtering to allow separate colleagues to filter their required data set. This has been set up using a custom toolbar with CommandBar drop down.
However the sheet is also protected so to allow the filtering to work it is unprotected filtered then reprotected. It works fine as an isolated workbook, but I have recently tried to share it to allow colleagues shared access. This has then thrown up errors in the code which arent their when its not shared.
Am I to understand that this is a problem created by the sharing and if so is it possible to share a protected workbook with these characteristics.
Many thanks in advance.
Neil