Forum Discussion
Niktia
Jan 19, 2022Copper Contributor
Hiding rows and columns from individual users in a shared table
Good day! Can I somehow hide the columns in the general table for specific users? With the "IMPORTRANGE" formula, you have to create many tables, which is inconvenient.
bosinander
Jan 19, 2022Steel Contributor
Hi Niktia
I don't know if this will be the best way for you but it may be one way;
First, getting the current user can be done using an old version of macros by defining it as a name.
=GET.WORKBOOK(35)...and in a cell the formula =windowsUser
The workbook will have to be saved as an xlsm since it holds active content, fetching data from outside excel.