+ Reply to Thread
Results 1 to 2 of 2

VBA - "Enable Content" using VBA

  1. #1
    Registered User
    Join Date
    04-21-2020
    Location
    Hydearabad
    MS-Off Ver
    2013
    Posts
    1

    VBA - "Enable Content" using VBA

    Hi,

    I have a static HTML page where I need to link an Excel file which has Macros in it. (Which is working absolutely fine)

    However after clicking the link and open the Excel sheet which is macro enabled every time it shows a Security Alert "Macros have been disabled - Enable Content".

    Please let me know how can I force Enable Macros.

    Reason: The Reason why I need to Force Enable is, I have added a Userform to this sheet and Userform should open when I click on particular link in the HTML Page but because of this POP up first it ask the user to Enable Content when he/she does it then Userform will open which is not that Effective.

    Kindly let me know the possible solution to get rid of this Security Warning.

    FYI: I am using Excel 2013

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: VBA - "Enable Content" using VBA

    Please let me know how can I force Enable Macros.
    You can't. That would rather defeat the purpose of Excel/VBA security.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. "Enable Content" pop-up after creating macro
    By scgormley89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2019, 10:46 AM
  2. Can I ENABLE the "enable editing" protection on one file after I greenlit it?
    By Oppressed1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-04-2019, 08:23 PM
  3. Receiving "enable content" warning after executing "save as" code
    By phbryan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-11-2014, 12:02 PM
  4. [SOLVED] formula help: conditional format of one column based on "YES"/"NO" content of four others!
    By 10 Dollar Bill in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-20-2014, 01:59 PM
  5. [SOLVED] What is difference between "update" and "enable content" ?
    By FRANKinATLANTA in forum Excel General
    Replies: 6
    Last Post: 03-18-2014, 02:21 PM
  6. How to change a Command Button caption from "Enable" to "Disable"?
    By Infinity in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2007, 12:14 AM
  7. Replies: 0
    Last Post: 06-01-2006, 08:10 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