ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   displaying a col based on nt account. (https://www.excelbanter.com/excel-programming/327008-displaying-col-based-nt-account.html)

TC

displaying a col based on nt account.
 
I am trying to show a col if and only if the user has the right Windows
permissions. I have found out how to hide a col when the book is opened but
the data is still there and the col can be expanded to display the data.

Is there a better way to do this so that the information is not available at
all if they do not have the right permissions?

I thought about copying the data from another spreadsheet if the permission
is correct. Will this work? If so how do I check the permissions? Will the
PermissionFromPolicy function work.

Thanks in advance,

TC

Thanks in advance.


All times are GMT +1. The time now is 05:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com