Would a loop help solve my problem?

[abenny11]

Hello genius people. I need some help again. Hoping someone out there smarter than me can help. I am learning VBA code, and have used this forum for much of my progress so far - so thank you!
Here is my issue:
I have a spreadsheet "form".. Customers use it to "build" what they want to buy.
I have code that prompts the user to enter a specific password that populates that given customer's specific discount.
The issue is that once that process occurs, if any further changes are made in the spreadsheet, the discount disappears and the customer would need to reenter their password. Is there any way that this can fixed? i would really like to have the discount remain in tact no matter what changes are made to the spreadsheet. My code is below. It is most probably not the best.. Any suggestions are greatly appreciated!

Please Login or Register  to view this content.

[p24leclerc]

Why don't you move this code to the Worksheet_Activate() event? It would be done only once when the sheet is activated.
Or it could be done on the Workbook_Open() event too.

[abenny11]

I will definitely try that! Thank you so much for the reply!