Saving XLSM as XLSX and removing buttons

Originally Posted by smuzoen

Please Login or Register  to view this content.

Hope this helps

So i found SMUZOEN provided this code for a question similar to mine but my spreadsheet will be going out to ~60 people, most of whom will try to push the VBA buttons (which, when saved as XLSX are useless) and get frusterated why they dont work.. Is there a way to get it to save as XLSX and remove the [Button(Form Control)]'s on all the sheets in the workbook? My workbooks contains 3-8 sheets per workbook so it's a bother to go through and delete every button, every time.

awesome but i'm still noobish so where would i put this into ?

my guess is right under SUB, that way it deletes before saving, correct?

Correct (try it and see )