Hello All,

I have a sheet where users will fill in some values and print it. It is a template and print form substitution. I would like to have a button on the sheet that will save the whole workbook as an xls file with the file name from a value stored in the K1 cell.
For instance, if the K1 has the 'abc123' value in it, and the user clicks on the ‘save’ button, the workbook should be saved as abc123.xls. Next, I would like to have a ‘clear’ button, and when user clicks on the ‘clear’ button, all defined (unlocked and unprotected) cell content will be removed (sheet reset). How can I do it?

Thank you,

Danield_sk