Need a small edit for some VBA code that runs a table of contents

[richard11153]

I have some code in a workbook i am making that gives me an "Auto Updating" table of contents" (TOC).
It works well, but when I added a "1st page cover" the TOC still shows as the 2nd page. (See worksheet attached)
I want the TOC page to be the 2nd page, and show as the 2nd page on the TOC
I also never want the page "Radon" to show in the table of contents.
Can someone with VBA skills help me with this.
Any help is very much appreciated!!
(The wook book is attached)
Thank you / Richard

[Greg M]

Hi there,

See if the attached workbook does what you need. It uses the following code:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[richard11153]

Yes, Thank you so much. I am bad at code so I really appreciate it.
Can I ask one more thing?
I will be adding a page at the end of the report i'm working on, that I do not want to show on the TOC,
I will name it "Radon". It will be the last page. Can that be done? If so, another sample please?
Thanks again.

[AliGW]

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[richard11153]

Greg, I ran into a problem. Can the TOC be page 2? I tried to add a "cover page" and it does not show in order
as I would like it to.

[richard11153]

Greg,
I attached a sample (with your code that I made some changes to)
One thing that is wrong now is I added a "cover page" as the 1st page, but is does not show
properly in the TOC (See worksheet). Also, can I make so the last page (the "Radon" page) be
not included in the TOC??
Thanks Soooo much for any help you can give.
Regards / Richard

[AliGW]

@Richard

You used this at the end of your code:

Please Login or Register  to view this content.

For future reference, it needs to be this:

Please Login or Register  to view this content.

[/noparse][/CODE]

I will correct it for you today, but please make sure that you remember how to do it next time.

Thread now open to responses.

[Greg M]

Hi there,

Take a look at the attached version of your workbook and see if it does what you need. It uses the following code:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[Greg M]

Hi again,

Many thanks for the Reputation increase - much appreciated!

Glad I was able to help.

Best regards,

Greg M

[AliGW]

Oh, dear ...

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[richard11153]

Are you sure this is still a "Help Fourm"?
I have never had problems like this in all the years I have used this.