Forum Discussion
Creating a contents page
Hi
Firstly apologies, but the file I sent you was password protected for the VBA. The attached file is an unprotected copy so use that one instead.
With both your workbook open and my latest file open.
Press F11 to invoke the VB Editor and you will see the Project Explorer with your files in the left hand pane and you will see the module called mod_Tech4u.
Just drag it up (or down) to your file and a copy will be created there.
Press Alt+F11 to return back to Excel and then save your file but remember to save it as a .xlsm or a .xlsb file in order for the code to be saved.
Hi
Attached is an extract from what I use for my clients.
If you insert the sheet TOC into your file, and copy across the code in Module 1 to your file, then this should do what you want.
- Hi
Thanks! How do I go about copying across the code?Hi
Firstly apologies, but the file I sent you was password protected for the VBA. The attached file is an unprotected copy so use that one instead.
With both your workbook open and my latest file open.
Press F11 to invoke the VB Editor and you will see the Project Explorer with your files in the left hand pane and you will see the module called mod_Tech4u.
Just drag it up (or down) to your file and a copy will be created there.
Press Alt+F11 to return back to Excel and then save your file but remember to save it as a .xlsm or a .xlsb file in order for the code to be saved.
