Switching off 'Save preview picture' in Excel
Bostjan wrote:
Is it possible to swith off the option to save preview
picture (File-Properties) with a macro?
Better late than never?
Sub NoPreviewPic()
SendKeys "^{PGUP}^{HOME}^{PGDN}+{TAB}+{TAB}+{TAB}-{TAB}{ENTER}"
Application.Dialogs(xlDialogProperties).Show
End Sub
Yuk!
I've submitted a request for programmatic access to this setting.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
|