Results 1 to 7 of 7

ThisWorkbook macros stopped working

Threaded View

  1. #1
    Registered User
    Join Date
    10-07-2008
    Location
    United Kingdon
    Posts
    7

    ThisWorkbook macros stopped working

    I have several Excel 2000 workbooks with vba macros in ThisWorkbook controlling what happens when a workbook is opened, activated or closed. These workbooks are in use by several users on different PCs and all macros were working fine with no problems whatsoever.

    Suddenly, they no longer work on any PC for any user. For now I have had to use the old method of Sub Auto_open() and Sub Auto_close() in the main module.

    So I have two questions:
    1. Does anyone know of a security patch or similar that could stop macros in ThisWorkbook from running?
    2. Does anyone know of an alternative to ThisWorkbook "Sub Workbook_Activate()" macro that I could use in the main module?

    Thanks
    Last edited by smited01; 10-09-2008 at 08:21 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 macros have stopped working
    By altidude in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-03-2009, 02:53 PM
  2. Macros stopped working on one server only
    By gerelda in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2008, 08:36 PM
  3. Macros are not working on a Mac
    By vjboaz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-23-2008, 03:25 PM
  4. VBA Stopped Working!
    By SamuelT in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-16-2007, 11:12 AM
  5. [SOLVED] My formulas stopped working
    By gmoexcel in forum Excel General
    Replies: 1
    Last Post: 11-22-2006, 10:59 PM

Tags for this Thread

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