Wish to apply "Save Preview Picture" in 300 files.

J

Jim May

I've created 300 files none of which show in the "preview-screen" when I
do a File Open. The setting of course is in the File Properties, Summay Tab
(chk box at bottom); I tried via Record-Macro, but no results; Any ideas as
to how to Loop thru complete Folder (containing the 300 and apply this
setting)?
Tks in Advance..
 
R

Ron de Bruin

Hi Jim

As far as I know it is not possible with code

This is old post from Bill Manville to turn it of

Sub NoPreviewPic()
SendKeys "^{PGUP}^{HOME}^{PGDN}+{TAB}+{TAB}+{TAB}-{TAB}{ENTER}"
Application.Dialogs(xlDialogProperties).Show
End Sub
 
Top