MACRO save active sheet wth name from selected cell and without macros and buttons

Ok

In this workbook there is a sheet specific macro on sheet: Main2

leaving that sheet will save Main2 to a folder called pics on the desktop using the name in cell a1.

I havn't time at the momenr to check if that folder exists and to create it for you. [ Will do that in a couple of hours when I get back. ]

Right click on main2 at the bottom of excel to view the code.

Enjoy.