Hello,
I have two columns in my sheet that I want to see as administrator but I want to keep them invisible (not hidden) for everyone that use it in read mode. Is it even possible?
Kind regards,
Daniel
Hello,
I have two columns in my sheet that I want to see as administrator but I want to keep them invisible (not hidden) for everyone that use it in read mode. Is it even possible?
Kind regards,
Daniel
everything what inside, sooner or later in some way is possible to read.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Can you answer to my question please? I just need to know how to do this.
You can make worksheets (tabs) invisible to users, but if the user can see a sheet, they're going to see that the column headers jump from A to D, for example. You can hide the columns, and make the users unable to unhide them, but you can't make it look like those columns don't exist.
If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.
If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.
you can change font/background for the same + locked/hidden in Protection properties for these columns + data validation cheat to display nothing + password protection on sheet, but it is still does not matter, if user wants to get value from these cells he can get it.
Check this thread:
https://www.excelforum.com/excel-gen...invisible.html
Last edited by KOKOSEK; 05-15-2019 at 11:37 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks