preview all files
 

Set ALL files to show a preview as in thumbnails, at once.

preview all files
 

Cannot be done.

Each workbook must be individually saved with that attribute checked under
FilePropertiesSummary tabSave 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



On Sat, 22 Mar 2008 07:48:00 -0700, sussertown
wrote:

Set ALL files to show a preview as in thumbnails, at once.