Each workbook must be individually saved with that attribute checked under
File>Properties>Summary tab>Save Preview Picture.
Unless you want code to loop through all workbooks in a folder, open them, set
the attribute then save/close.
I don't think I could help you much with that.
I don't know how to set the Save Preview Picture attribute.
Gord Dibben MS Excel MVP
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
