Panasonic Home Business > Industrial Devices > Automation Controls Top > Service & Support > Frequently Asked Questions

How do I use the Auto_Open operator with a specified BOOK only?

ID:
856
Issued:
Dec 28th, 2009
Updated:
May 17th, 2013

How do I use the Auto_Open operator with a specified BOOK only?

ANSWER
When you do not want to execute the Auto_Open operator when displaying a version history book etc.

Sub Auto_Open()
If the book name is not OpenTest.xls, return immediately.
If ActiveWorkbook.Name <> "OpenTest.xls" Then Exit Sub

(Execution code)
End Sub
RELATED CATEGORIES

Did you solve your problems?

YES

NO

Search Keywords


If you still have problems with our products,

FEEL FREE TO CONTACT US

Return to top