Password Setting on a macro button

Hello,

I have this macro and I want to add a password so that nobody is able to click the button for the macro.

If some user try to click the button, it will prompt a passcode with "cancel" option or return to worksheet.

Thanks.

Please Login or Register  to view this content.

You could use an inputbox or a UserForm, but it's not really secure and there's likely nothing to stop someone saving a copy manually or copying the file and renaming it.
"Documents" is usually associated with a User, but in any case the file is saved locally. What's the idea behind trying to prevent it?

As ByteMarks said, the password can easily be bypassed. In order to prevent unauthorized access to files at my place of work, we implement the use of Environ("USERNAME") function to check if the user is found in the list of authorized users.

This could be used in a similar fashion for this case;

In the ThisWorkbook pane in the VBA editor, try this code:

Please Login or Register  to view this content.

If you don't know your username you can run Environ("USERNAME") on yourself in a separate macro.

You can then set the VBA editor to be password protected on that file by right-clicking in the Project pane, selecting "VBAProject Properties", selecting "Protection" and enable the password protection and remove access to view the code.

If anyone other than yourself tries to run your original macro, they won't be able to save.