Hi,

I've created a eco tool, multiple formulas, multiple tabs (Summary,COGS,BE data,version control etc) all works great.

(for the summary page)I have a number of cells which are unlocked for colleagues to type in manually, i created a basic macro button to clear all that, however the boss has now asked to put in room for a text box, and space to paste a picture/diagram. i would like now have a button to clear the unlocked cells, the text in the text box, and the picture.

I recorded a macro to clear the unlocked cells, and i found some VBA script for the picture, so two buttons. still unsuccessful in finding how to delete text box (tried recording etc)

my VBA knowledge out of 100 is 1/100 (will start leaning soon)

Appreciate any hints and tips

thanks

Alv