I have a bunch of different worksheet and because the workbook is shared,
each sheet has code to display a userform1. The user inputs information and
then gets access to his/her sheet. I need to pull information off of there
sheet and don't want to be required to enter the username/password to get
access. Is there a way that I can write a macro to alter each sheets code to
not display the user form and then use the macro again to turn it back on.
Thanks,