macro to alter worksheet code

[Guest]

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,

 

[Shailesh Shah]

Hi,

See Chip Pearson' site

http://www.cpearson.com/excel/vbe.htm

for

1. Deleting A Procedure From A Module

2. Adding A Procedure To A Module


Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/