When you say "form" do you MEAN "form" as in Userform
or do you have a worksheet that resembles a form?

if you're using a Userform,
use a TextBox for the entry.
In the Properties panel of the textbox, there is a Password Character property.
Put a "*" there.
You can create a Workbook_BeforeClose event,
or a Worksheet_Deactivate event, or both
that could be used to re-protect the sheet.
You might want to include it instead in a Workbook_BeforeSave event
so that the user cannot save it in an unprotected state.
Of course, if you're using a worksheet template instead of a UserForm,
we'll have to look closer at the change events.

Yes, this helps a great deal. I have created userforms for my
spreadsheet for data entry, sorting, and modifications, but had no
idea how to handle the document once unprotected from the
modification userform. This helps. Thank you. I will look into the
workbook_beforesave & workbook_beforeclose events. Thank you.

Hello,

You can try to use Kernel VBA Password Recovery software,This Tool quickly recovers password of VBA project file irrespective of the password length and complexity.You can get more information from here http://www.vbapasswordrecovery.com/

you can also go for this link www.vbapasswordremover.net/...ssword-recovery.html