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.
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.