Re: Increase Code Efficiency
As you have only supplied a snippet of code and no description of the project, the "condensed" code I gave you made some assumptions eg, that the DeleteButtons subroutine exists somewhere in your project. I am not sure what this does as you did not include the code in your example.
Also, I had to presume that the labels you want to make visible were invisible to begin with (ie, at design time).
The Private variable has to be placed at the top of the UserForm module.
To show you how this all hangs together, a sample "dummy" file is attached with the code in it. If you give it the correct password, the corresponding label will display. You will have to run the UserForm1 manually, I have not added any code to launch this automatically.