View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bill Manville Bill Manville is offline
external usenet poster
 
Posts: 473
Default 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