Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Dorset UK
    Posts
    147

    Question Unanswered: Before save in personal macro

    Hi,

    I usually help people in the Access database forums but I need help now..

    I am trying to find code that enables a module written in the 'personal macro' space to do an event on ANY open workbook before it is saved.

    Basically theres a number of worksheets that are confidential, and we want to create a list in a txt file of who saved the workbooks last and when.

    Any takers to try and help me ???

    Thanx in advance

    Ken

    PS I know I can do this under the workbook function of each individual sheet. But we'd like it to be centralised, so that if new books are created they'd be included.

  2. #2
    Join Date
    Feb 2004
    Location
    Dorset UK
    Posts
    147

    Solved it

    I have solved the problem..

    I have effectivily written code that initiates when Excel opens, and can trap all events.

    If anyone needs the code, PM me.

    Regards

    Ken.

Posting Permissions

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