Hi All

I am looking for some ways to extend my code for a button, which currently "save as" the active worksheet when the button is pressed. But now I want to add the following. Not sure how...

When the Same button is pressed, It must save the active worksheet and remove all the Formulas (only Values) from that sheet (Which will be saved in a folder) and also delete the worksheet from the Master Workbook. Then lastly if an Operator has made the Save, he cant change anything on the worksheet unless by password which I will have to enter to activate all cells again.

This is my current code for the button:

Please Login or Register  to view this content.
Surly looking forward to some answers.

Many thanks
Ronette