How to remove pages from a multipage?

**marlonsaveri** · 05-25-2011, 07:21 PM

Hi, I tried something like:

Please Login or Register  to view this content.

but it's wrong.

What's the right way to delete a (all) page(s)?

**shg** · 05-25-2011, 07:23 PM

Either loop backwards, or

Please Login or Register  to view this content.

**marlonsaveri** · 05-25-2011, 07:31 PM

Thanks, but It also didn't run. Error 5

nor:

Please Login or Register  to view this content.

**marlonsaveri** · 05-25-2011, 07:41 PM

Nor:

Please Login or Register  to view this content.

**shg** · 05-25-2011, 07:51 PM

You can only remove controls (Pages) added at run-time, not design time.

This was wrong (my bad):

Please Login or Register  to view this content.

The first element of the Pages collection is 0, not 1.

**Leith Ross** · 05-25-2011, 07:55 PM

Hello marlonsaveri,

Are you executing the macro from a VBA module or the UserForm?

**marlonsaveri** · 05-25-2011, 08:01 PM

Thanks shg and Leith (in a Userform)

Now I think we solved the problem with:

Please Login or Register  to view this content.

For example, if we had 2 pages: j = 2, but, as shg said, the first one is 0. Then, g begins in 0 and goes until j-1 = 1 (del page 0 and page1)

Re: How to remove pages from a multipage?