Refreshing shapes that cause excel to not save

[scottiex]

So I have problem that sometimes (but not often) occurs with a sheet I have created.
The sheet has a number of shapes in it that I use as buttons and it seems that sometimes this will cause excel to have the 'Errors were detected while saving" error. (I imagine that others may have encountered this issue).

The fix I have found is to delete those shapes and then to put them back in again. But that is going to be quite a pain to do manually with a large number of shapes to name and position exactly right.

So I want to be able to recreate the buttons on the sheet.

I have a template that I could copy the shapes or the shape settings from. So my tentative thought was that I could delete all the shapes and then for every shape I find in the template go to the main file and create something identical (I think these are all that matters : name, text, type, left top width and height and macro linked to it)?

Although it would also be good if it just recorded the shape settings deleted them and recreated them.