Results 1 to 5 of 5

"Open document with macros enabled".

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-10-2006
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2019, Win 10
    Posts
    102

    "Open document with macros enabled".

    Excel 2000.
    I am a raw beginner to VBA and this function is brilliant! Something I had wanted for a looong time.
    I then changed the code (in a second module) to 'UnProtect'. That worked too!

    However, after saving the protected workbook and re-opening, the macros are disabled, and a message appears: "Open document with macros enabled".

    How on earth do I do that? I can find no obvious solution. It's probably staring me in the face if I looked hard enough.

    TIA

    Alan
    Last edited by Zagra147; 12-22-2009 at 10:57 AM. Reason: Hyjacked Thread, Moved to own thread

Thread Information

Users Browsing this Thread

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

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