I have been asked to delete the macros and code etc from a workbook.
I have found code on the internet at http://www.cpearson.com/excel/vbe.aspx
unfortunatly having tested it it seems that changes I make to the excel settings stay with my lap top and do not get transferred with the workbook that is E-mailed to other users.
I need to be able to delete macros and code without having to change any lap top settings.
strange as it may seem I think that if i can delete this stuff via code I can afford for the macro that does this to also be deleted. It looks as if all the code to be deleted is held in only 1 sheet .
I hope I have asked the right question
smiler44
I have found code on the internet at http://www.cpearson.com/excel/vbe.aspx
unfortunatly having tested it it seems that changes I make to the excel settings stay with my lap top and do not get transferred with the workbook that is E-mailed to other users.
I need to be able to delete macros and code without having to change any lap top settings.
strange as it may seem I think that if i can delete this stuff via code I can afford for the macro that does this to also be deleted. It looks as if all the code to be deleted is held in only 1 sheet .
I hope I have asked the right question
smiler44
