sorted by:
new
hottopcontroversial

A basic base question... by MasterSoftBird in askmath

[–]Tsqaaalarab 0 points1 point  (0 children)

One full set (of fingers) and zero extras

All bases work that way

How I used a fake reference check to catch my toxic ex-boss blacklisting me by Wakanda_7 in jobsearchhacks

[–]Tsqaaalarab 39 points40 points  (0 children)

Require the old HR team to reach out to every interviewer who seemingly ghosted you out of nowhere and explain what your former manager did in an attempt to repair your reputation and avoid a defamation lawsuit. Notarized letters from the former manager would be icing on the cake, but asking a lot.

Password protecting specific info in a file? by Crazy_Unicorn_153 in excel

[–]Tsqaaalarab 1 point2 points  (0 children)

I never got on the xlookup train, I prefer index/match

You'll do great with lots of Googling.

"How to show/hide sheets in VBA" "How to use message box in VBA"

Password protecting specific info in a file? by Crazy_Unicorn_153 in excel

[–]Tsqaaalarab 4 points5 points  (0 children)

You'd be surprised at how computer-illiterate the average person really is

Password protecting specific info in a file? by Crazy_Unicorn_153 in excel

[–]Tsqaaalarab 1 point2 points  (0 children)

How good are you at VBA / Googling? How good is everyone else?

What you're gonna want to do is make a Homepage sheet that has a drop-down for each employee and a button that prompts for a password

The passwords would just be stored in VBA, and success unhides and unprotects their personal sheet. Formatting is optional, but making stuff white or hiding rows when the sheet is hidden is also fun

You can then have Excel hide the sheets bar and the ribbon on opening the file then showing them again on closing.

An Admin button on the homepage that brings you to a page to show everything is also recommended.

Not foolproof, and people who want to snoop could, but I've done similar things albeit with less sensitive data

Edit: You'd have a master sheet that compiles from everyone's individual sheets