View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dean Meyer[_2_] Dean Meyer[_2_] is offline
external usenet poster
 
Posts: 12
Default Name disappears after Application.Run

A bug in Excel 2007 causes the name immediately following Print_Titles to
disappear from a workbook after Application.Run has called a routine in the
workbook, then the workbook is closed and reopened.

TO REPLICATE:
Create 2 workbooks: Master.xlsm and Slave.xlsm

In Slave.xlsm, do two things:
1) Name a range QQQ (such that it follows Print_Titles)
2) Create a VB macro called NoOp that does nothing.

In Master.xlsm:
1) Create a VB macro that does:
Application.Run "'Slave.xlsm'!NoOp"

Now, close Slave (with or without saving it), keeping Master open. Reopen
Slave, and the first name following Print_Titles cannot load. It's in the
file, but not in the name manager when the file is loaded.

WORKAROUND: Always ensure there is a name Print_Titles_ZZZZZZ, replace if
missing on WorkbookOpen.

QUESTION: Is there any other damage caused by this bug that I haven't
discovered yet?