Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Searching VBA code to disable excel compatibilty checker

Hi,

i'm searching the right VBA code that disables the Excel Compatibility
Checker. (office 2007)
Since I want to apply changes to over 1.000 excel-files during nights.
(sheets saved in xls-format)

thank you
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,533
Default Searching VBA code to disable excel compatibilty checker

Hi

This should do it:

Application.DisplayAlerts = False

Just remember to set True again.

Regards,
Per


"bartvd" skrev i meddelelsen
...
Hi,

i'm searching the right VBA code that disables the Excel Compatibility
Checker. (office 2007)
Since I want to apply changes to over 1.000 excel-files during nights.
(sheets saved in xls-format)

thank you


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel file in compatibilty mode and not all sheets within the fil. Excel file in Compatibilty Mode ??? Excel Worksheet Functions 0 April 12th 09 12:31 PM
disable the Compatibility Checker in Excel Jack Excel Discussion (Misc queries) 0 September 24th 07 05:36 PM
Code to configure Spell Checker Gordon[_2_] Excel Programming 0 September 10th 06 04:44 PM
Excel 2003 vs 2000 VBA Compatibilty SteveM Excel Programming 3 June 7th 06 01:55 PM


All times are GMT +1. The time now is 02:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"