No, records the first macro as per the link in the previous post.

Then press ALT + F11 this will open the vba editor

In the left pane you should see VBAProject(PERSONAL.XLSB)

Right click on the module folder and insert module

Then in the right pane paste in the code

Once that is done you will be best off to create a button in your quick access toolbar for ease of use

Let me know how you get on

Attached Files

withpictures.docx (50.8 KB, 6 views)