For non-technical users or modern encrypted files, specialized tools are the most reliable way to reset a VBA password.
: Go to Tools > VBAProject Properties > Protection in the VBA editor, set a new password, save, and reopen the file to finalize the reset. Prevention and Proper Protection Reset VBA Password