Make a Password Prompt Input for Excel (With Masked Input)

Add to Favorites
Author: | Edits: don

How to make a Password input prompt window for Excel and mask the input so that you can't see what is being typed into the window.

This tutorial also shows you how to:

  • Create a Basic UserForm in Excel
  • Run a UserForm in Excel
  • Close a UserForm in Excel
  • Mask Input in Excel

This tutorial is made for beginners, and, though it requires using a little bit of VBA and creating a UserForm, the entire process is shown in an easy-to-follow manner from start to finish.

Additional Resources

Require a Password to View Hidden Worksheets in Excel

Masking Password Input (microsoft resource)

UserForm PasswordChar Property (microsoft resource)


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

Similar Content on TeachExcel
Make a Drop Down List Menu in a Cell in Excel
Tutorial: I'll show you how to make a drop down list menu in a cell in Excel. This allows you to ha...
Generate a Unique List of Random Numbers With a Simple Formula
Tutorial: Sections: Versatile Formula to Generate a Unique List of Numbers Excel 365 Formula to Gen...
Automatically Run a Macro When a Workbook is Opened
Tutorial: How to make a macro run automatically after a workbook is opened and before anything els...
How to Create and Manage a Chart in Excel
Tutorial: In this tutorial I am going to introduce you to creating and managing charts in Excel. Bef...
Allow Only Certain People to Edit Specific Cells in Excel
Tutorial: How to allow only certain people to edit certain cells or ranges in Excel. This is a sec...
Input Form to Get Data and Store it in Another Tab in Excel
Tutorial: How to make a user input form in Excel and have the data stored on another worksheet at th...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)