Protect sensitive information

Many applications use data that should be available only to certain users. Here are some suggestions you can use to protect sensitive information in Microsoft Forms:

  • Write code that makes a control (and its data) invisible to unauthorized users. The Visible property makes a control visible or invisible.

  • Write code that sets the control's foreground and background to the same color when unauthorized users run the application. This hides the information from unauthorized users. The ForeColor and BackColor properties determine the foreground color and the background color.

  • Disable the control when unauthorized users run the application. The Enabled property determines when a control is disabled.

  • Require a password for access to the application or a specific control. Use placeholders as the user types each character. The [PasswordChar]((passwordchar-property.md) property defines placeholder characters.

Note

Using passwords or any other techniques listed can improve the security of your application, but does not guarantee the prevention of unauthorized access to your data.

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.