macro to fix macro?

[wmtsub]

There is a spreadsheet that is print protected[indented for third party input directly into the sheet - like a questionnaire]. It was print protected in the "

Thisworkbook" so that the 3rd part would need to populate it and return it electronically. However we shot ourselves in the foot as WE need to print it. I will fix the outgoing worksheet but there is a need to print what we already have received. So ​

I need a macro to clean any existing macro in the workbook "Vendor Set-Up" "Thisworkbook" module and it would be nice if it could also save and close the workbook

This is beyond me. Can anyone help?

Thanks.

 

[Fluff]

Just open the file in safe mode, that disables macros.

 

[wmtsub]

Thanks but that is not an option. I wuld like to run a macro to do so. Is that possible?

 

[Fluff]

Not sure why you feel the need to have a macro, if you don't want to to open the file in safe mode, either open normally & disable the macro,or open the file from a folder that is not trusted.
Those options are a lot easier & safer than using a macro to delete other macros.

 

[Stiuart_W]

My advice would be to go back to the people that wrote this Excel for you and pay them to provide you with different functionality or to provide you with the IP so you can change it at will