Removing Userforms

**SDA** · 06-25-2008, 05:39 AM

Hi

Is it possible to remove userforms using VBA, I have tried

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

**Andy Pope** · 06-25-2008, 08:56 AM

Do you mean you want to remove the useform and associated code from a vba project using vba code?

If so you will need to access the userform via the VBE object model.

Why do you need to do this?

**SDA** · 06-25-2008, 11:18 AM

Hi

I have a form made up of a series of user forms (30+) they are all coded and the different forms open according to the information you input (about 6 max). The Data is then transfered to an excel sheet and emailed to the admin team who do not need the user friendly format. I want to remove the userforms in order to make the file size smaller.

cheers
Si

**Andy Pope** · 06-25-2008, 11:24 AM

See Chip's page on programming the vbe
http://www.cpearson.com/excel/vbe.aspx

**SDA** · 07-15-2008, 06:21 AM

Thanks Andy, this link proved very useful. I have come across another hurdle I cannot get over.

the VBA code is password protected, I know the password but I cannot get the VBE object to access it. I've tried "unprotect("password")" . is there a special way to unprotect it and reprotect it?

cheers
Si