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.

  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


  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 at 3:24 PM.

  1. sms2luv

    sms2luv Member

    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.
  2. Hui

    Hui Excel Ninja Staff Member

    Change the line

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

    To: If ws.Name <> "Start" Then
  3. sms2luv

    sms2luv Member

    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

Share This Page