Hi
Am quite new to VBA programming.
I am sharing a spreadsheet with my clients on a host website. There are a number of different clients on the spreadsheet but I have only given each client access to a filtered version that shows their data alone.
It is password protected but in theory they could Save what they see under a different name and then use the filter arrows to view other client's data.
Does anyone know of a simple macro I can write to stop this happening or, indeed, is there a non VBA solution?
Many thanks
Am quite new to VBA programming.
I am sharing a spreadsheet with my clients on a host website. There are a number of different clients on the spreadsheet but I have only given each client access to a filtered version that shows their data alone.
It is password protected but in theory they could Save what they see under a different name and then use the filter arrows to view other client's data.
Does anyone know of a simple macro I can write to stop this happening or, indeed, is there a non VBA solution?
Many thanks
