Error message on saving file after running macro

Hi,

I have a master file with 14 tabs which do the calculations. I use the macro below to copy the tab 'Highlights' from all the other individual files in the folder. The macro executes fine but when I try to save the file, it comes with up with an error message and I cannot save it. Could someone tell me where I am going wrong. I use Excel 2010

Please Login or Register  to view this content.

Some idea of what the error is would be useful.

Hi, Please see error messages below.....

'Errors were detected while saving 'C:\Documents\Highlights.xlsm'. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the dile, click Cancel.'

and when I click 'Continue',
'Excel encountered errors during save. However, Excel was able to minimally save your file to C:\Users\........'

Does this make any difference?

Please Login or Register  to view this content.

Any images being copied?

Hi John....tried your code...it all runs fine and can see all tabs being copied in. And then at the end, all the added sheets disappear and the file becomes read-only..so the file name changes to Thisworkbook.FullName (Read only). Didnt try to save it as all the added sheets had in any case disappeared!

Hi grimes, thanks for that!! Yes, indeed...there were a couple of images on one of the worksheets being copied over. Deleting those images seem to have done the trick and I am now able to save. Thank you so much.

See this: https://support.microsoft.com/en-us/kb/2597034