Password Mask Cell in Excel

I want to make the Cell in an Excel to be Password masked with * symbol

How would i achieve this
srikanthv2322Asked:
Who is Participating?
 
DaveConnect With a Mentor Commented:
While I don't think you could do this directly, depending on how you want users to access the cell you could

- protect the sheet
- put a textbox with a "***" over the cell
- use a UserForm or other code to write the actual cell contents

Do you have a sample or concept to expand upon?

Cheers

Dave
0
 
MakriniConnect With a Mentor Commented:
You can use a "Custom Format" as per below...

"*";"*";"*";"*"

As Dave said though you probably need to protect the sheet to hide the contents of the formula bar.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.