Hi,

Can anyone help me with a macro? i need a macro to delete a work book either
on close or if a cell is altered. the reasons are for company security
purposes where the book needs to be viewed but not kept as passwords can be
cracked and delicate information can be extracted. If i pdf it though, it is
only a viewable page where the certain functions won't work.

I need the user to be able to open the book, view and use the book but when
the book is to be saved as, it will delete. also when they close the book,
all data will not be saved and the book needs to delete itself.

Can this be achieved?

Regards,

Nigel

Hi Nigel

This is possible with code but if the use disable macro's it is not working

Save the file as PDF
http://www.mvps.org/dmcritchie/excel/pdf.htm


--
Regards Ron De Bruin
http://www.rondebruin.nl



"Nigel" wrote in message ...
Hi,

Can anyone help me with a macro? i need a macro to delete a work book either
on close or if a cell is altered. the reasons are for company security
purposes where the book needs to be viewed but not kept as passwords can be
cracked and delicate information can be extracted. If i pdf it though, it is
only a viewable page where the certain functions won't work.

I need the user to be able to open the book, view and use the book but when
the book is to be saved as, it will delete. also when they close the book,
all data will not be saved and the book needs to delete itself.

Can this be achieved?

Regards,

Nigel