• The forum (and all other resources in Chandoo.org) will be under maintenance and will be unavailable for a maximum of two hours on the first week of October 2023. The exact date, time and duration of the maintenance are subject to change. We regret the inconvience it may cause.
  • 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


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

Profile post for Luke M

  • Deleted by Luke M
Hello, I was wondering if there is a way to run a macro whenever any workbook is opened? I know how to code a regular workbook_open event. Specifically, what I'm after is whenever a workbook is opened, to have VBA evaluate if workbook contains a specific sheet and specific value in that sheet in cell B5, and advise the user if the Sheet is available and cell value is not equal to "1234".