+ Reply to Thread
Results 1 to 5 of 5

Disabled Macros

Hybrid View

  1. #1
    MBlake
    Guest

    Disabled Macros

    Hi,
    Is there any VBA code that closes the Workbook if a user does not agree to
    enable macros on startup?.

    TIA,
    Mickey



  2. #2
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161

    Workbook to open a workbook!

    Hi what i suggest you do is create a workbook with an auto_open sub in it which calls the workbook you want them to be able to work on this way if the first workbook has Macros Disabled by the user then it will not call your workbook!

    HTH

    Simon

  3. #3
    Paul B
    Guest

    Re: Disabled Macros

    MDlake, if the user does not enable macros how is the code to close the
    workbook going to run? Have a look here for a workaround

    http://www.danielklann.com/excel/for...be_enabled.htm
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003


    "MBlake" <mickeyblake@btinternet.com> wrote in message
    news:OinmZEjVFHA.3280@TK2MSFTNGP09.phx.gbl...
    > Hi,
    > Is there any VBA code that closes the Workbook if a user does not agree to
    > enable macros on startup?.
    >
    > TIA,
    > Mickey
    >




  4. #4
    Charlie
    Guest

    RE: Disabled Macros

    Maybe you could lock and protect the entire workbook and have the startup
    macro unlock it. That way if the user does not enable the macros the
    workbook will be useless.

    "MBlake" wrote:

    > Hi,
    > Is there any VBA code that closes the Workbook if a user does not agree to
    > enable macros on startup?.
    >
    > TIA,
    > Mickey
    >
    >
    >


  5. #5
    MBlake
    Guest

    Re: Disabled Macros

    Thanks for the replies, I looked at the code suggested and also a resource
    here which I found very useful, others may as well -
    http://www.vbaexpress.com/kb/getarti...b_id=379#instr

    Thanks again,
    Mickey



+ Reply to 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