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.
Bookmarks