I have a single column of data I would prefer to keep on a spreadsheet, but I want it to be hidden and password-protected so nobody but me can see it. Maybe also make it read-only in case they somehow see it (but ideally I'd like them to not see it) Is this possible?
Thanks
Yes, hide the column, then protect the worksheet (ensuring that 'Format Columns' is unticked) - Review ribbon, Protect Sheet
You can use a password for the protection. Be aware it's never 100% secure.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
If I did this, would they still be able to filter the data on the worksheet? I don't want them editing data, but they need to use the filters I've set to sort data.
Yes - tick the 'Use Autofilter' option, in the Protect Sheet dialog.
Thank you- that worked :-) And thanks especially for the quick response!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks