deleting pictures

[kevin carter]

hi
i have a workbook that allows a user to select a picture and other data.
Once the picture has been selected it is pasted into another location on the
worksheet.

What i want to do is when the user has finished and the workbook saved, i
want to reset the worksheet to default values
this means deleting the picture and the other data.
i do this by clicking one button which runs a macro

the text is no problem
is it possable to delete a picture ?

thanks kevin

 

[Dave Peterson]

You can delete a picture in code by something like:
activesheet.pictures(1).delete

or if you know the name:
activesheet.pictures("myPictureName").delete

but if you're going to reset the workbook, why not just make the workbook
readonly.

If they want to save their copy, they can--as a new name.

But the won't be able to touch the original.

(You could save your workbook as a template (.xlt) and have them create a brand
new workbook based on your template.)

 

[kevin carter]

thanks for your help

You can delete a picture in code by something like:
activesheet.pictures(1).delete

or if you know the name:
activesheet.pictures("myPictureName").delete

but if you're going to reset the workbook, why not just make the workbook
readonly.

If they want to save their copy, they can--as a new name.

But the won't be able to touch the original.

(You could save your workbook as a template (.xlt) and have them create a brand
new workbook based on your template.)