• 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".