N
Nigel
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
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