1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro Check

Discussion in 'VBA Macros' started by sms2luv, Aug 12, 2017.

  1. sms2luv

    sms2luv Member

    Messages:
    270
    I am added a Macro to check if Macro is enabled for users of this file.

    If Macro is enable, it will display that its enable, and if its disable it will display to enable macro.

    Now whenever I close the file, I get error Method ‘Visible’ of object’_Worksheet’ failed

    Unable to upload file here, due to size limitation.
    http://www48.zippyshare.com/v/GUIqfi6c/file.html
  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    10,533
    Change the line

    From: If ws.Name <> "START" Then

    To: If ws.Name <> "Start" Then
    Thomas Kuriakose likes this.
  3. sms2luv

    sms2luv Member

    Messages:
    270
    This issue is solved, now a new issue came up.
    When I open the file, it says that macro is not enable.
    I have already changed setting to open all macro.
    Other macros works fine, only this code has an issue.
    One more issue is that before changing the code from START TO start the file was getting saved automatically
  4. Derek McGill

    Derek McGill Active Member

    Messages:
    130
    I have not looked at file and macro, But how can a macro to tell you to enable macros run ???
    SirJB7 likes this.
  5. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    15,069
    Thomas Kuriakose and sms2luv like this.
  6. sms2luv

    sms2luv Member

    Messages:
    270
    Hey guys,
    Issue was resolved, just by restarting system.
    SOLVED..
  7. Monty

    Monty Well-Known Member

    Messages:
    828
    Good solution!

Share This Page