Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Preventing auto_open and Workbook_Open events from running

Today’s author is Jan Karel Pieterse, an Excel MVP. You can find more useful tips from Jan Karel on his website: http://www.jkp-ads.com/ . This post informs you about Name Manager, a free utility that helps you manage defined names in your workbooks. As a fulltime developer I oftentimes open files containing VBA and want to be able to run code. At the same time I sometimes want to prevent Workbook_Open event code or an Auto_Open macro from running. This little article shows you how to achieve that Read More...

Read the complete post at http://blogs.msdn.com/excel/archive/2009/12/15/preventing-auto-open-and-workbook-open-events-from-running.aspx


Posted Dec 15 2009, 02:20 PM by Microsoft Excel
Filed under:
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.