I have a workbook that tracks my daily financial information at work. I have written a new macro that resets the workbook at the end of the week. However, it is critical that this macro not be run until that time.

Is there anyway to write a password prompt into the macro so that if someone accidentedly presses the button I have assigned to it, it is protected from being ran?

Currently, I have the button sitting on the page as a placeholder to keep this from happening.

Thanks,
Scott