Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Inconsistent Events

  1. #1
    Join Date
    25th May 2004
    Posts
    9

    Inconsistent Events

    I can not get the Document_Open, or the Document Close to trigger. These subroutines executed fine for a while, then just stopped working.

    I have both placed the code in the Normal and Project, ThisDocument. I should at least get the message box popping up when I start the program.

    Any suggestions, comments, of links to other resources.... Is there some code I am missing, or is WORD VBA simply this "buggy" / inconsistent.

    Code as follows:

    Option Explicit

    Private Sub Document_Open()
    MsgBox "start"
    Call AddMenu

    End Sub

    Private Sub Document_Close()
    ' * * * * * * * * * * * * * * * * * * * * * * * * * *
    ' Remove objects specific to this workbook.
    ' * * * * * * * * * * * * * * * * * * * * * * * * * *

    Application.DisplayAlerts = False
    Application.ScreenUpdating = False
    Call DeleteMenu

    End Sub

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    25th May 2004
    Posts
    9
    It was me... the macro security somewhere was changed to high. Start macro was never executing.... change back to medium, and runs like a champ.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    25th January 2003
    Location
    Pennsylvania USA
    Posts
    419
    Hee hee.
    Don'tcha HATE THAT!!??

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Ignore Inconsistent Formula
    By coolhandphil in forum EXCEL HELP
    Replies: 2
    Last Post: August 15th, 2007, 21:43
  2. Inconsistent Formula
    By cs2007 in forum EXCEL HELP
    Replies: 7
    Last Post: June 7th, 2007, 18:09
  3. Lookup With Inconsistent Data
    By melsmiff in forum EXCEL HELP
    Replies: 12
    Last Post: September 4th, 2006, 19:25
  4. inconsistent runtime error
    By Jaz in forum EXCEL HELP
    Replies: 4
    Last Post: October 5th, 2004, 19:05

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
  •  
porno