Add a Table of Contents to your Workbook Programmatically

If you need to create a Table of Contents for your workbook and update it periodically, this is a God-send!

I’ve just come across this link and not tried it out.  But based on just reading the codes, this will either update an existing TOC or create one if you don’t have it yet.

There is a manual portion though, you need to be at your computer to manually close the print preview screens generated.  The good side is that you decide how many pages each section/tab is, the downside, you can’t just run it and go off for a cup of coffee.

via Add a Table of Contents to your Workbook Programmatically.

Advertisements

Tagged: ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: