+ Reply to Thread
Results 1 to 5 of 5

Disable "Compile Error" Alert

  1. #1
    Forum Contributor
    Join Date
    09-28-2007
    Location
    New York, NY
    MS-Off Ver
    2007
    Posts
    120

    Disable "Compile Error" Alert

    is there a way to disable the compile error mesage box in vba? I'd still like to see the red syntax errors, but that message box is extremely annoying.

  2. #2
    Registered User
    Join Date
    08-20-2008
    Location
    Philippines
    MS-Off Ver
    Office 2007
    Posts
    18
    Same question here... "Compile error hidden module", I believe can't be handle even if you will create customize error handlers...

  3. #3
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    In the Visual Basic Editor, go to TOOLS-OPTIONS

    Uncheck the "Auto Syntax Check" check box.

    Now, you should not get the error.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436
    Why not fix the error?
    Cheers
    Andy
    www.andypope.info

  5. #5
    Forum Contributor
    Join Date
    09-28-2007
    Location
    New York, NY
    MS-Off Ver
    2007
    Posts
    120
    aha thats exactly it.

    sometimes i need to refer to another section of code before finishing a line so i click somewhere else in the code and that box opens up as if i didnt know there was a line of red code there.

    thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Disable alert
    By langwo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2008, 05:52 PM
  2. Disable the task pane shortcut
    By phenomenix in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2008, 11:48 AM
  3. Disable columns
    By games in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-07-2006, 03:21 PM
  4. disable macros
    By missing in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-18-2006, 03:16 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1