Code to make user enter a password in order to hit command button and execute macro

Hi,

I am building out a model that will be used by many people. Within the file is a command button used to run a macro that essentially aggregates data inputted on the various tabs into one tab that I use to import into a database. Unfortunately, some people have been hitting this command button when they shouldn't have. I inserted a message box so that if you hit the button, it pops and asks "Are you sure you are Michael and should be running this macro?" Unfortunately, I need to lock this down a little more now as some people insist on continually pressing my buttons (pun intended). Is there any way I can set up a message box that has a password that the user would have to input in order to execute this macro once the command button is pressed?

Thanks in advance.

Mike

yes it is possible but can you upload the sample file......



Regards
CA Mahaveer Somani