Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2006
    Location
    vancouver, Washington, USA
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Enabling Macros??? (v. 2000)

    Good morning,

    I've recently finished a pretty cool spreadsheet and have developed (with the help of you brilliant guys on this forum) several macros within it.
    It seems whenever my users try to use the spreadsheet and click on any of my custom buttons that run the macros... they get a dialog that says "macros are disabled, please enable macros."

    I've looked all over the Help files and cannot find where to enable macros. I see how to disable them, but not enable.

    Please help. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Enabling Macros??? (v. 2000)

    Under Tools-Macro-Security... you can change the level from High to Medium. They will then get prompted whether to allow the macros to run when they open the workbook. I wouldn't recommend setting the security to low.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    New Lounger
    Join Date
    Mar 2006
    Location
    vancouver, Washington, USA
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Enabling Macros??? (v. 2000)

    Rory...... thanks that did it!

Posting Permissions

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