Jilla,

my situation:
All code runs from my Personal.xls.
I create a menu were I need to check wether a certain sheet is
available in the opened Excel workbook. The menu is created in
ThisWorkbook of the Personal.xls, but the Personal.xls does not see the
sheet in the opening workbook.

What should I do?

Thanks


--
Zurn
------------------------------------------------------------------------
Zurn's Profile: http://www.excelforum.com/member.php...o&userid=14645
View this thread: http://www.excelforum.com/showthread...hreadid=532168

So I want my workbooks to open first, and directly afterwards make my
menu (= run the code)...


--
Zurn
------------------------------------------------------------------------
Zurn's Profile: http://www.excelforum.com/member.php...o&userid=14645
View this thread: http://www.excelforum.com/showthread...hreadid=532168

What about using ActiveWorkbook, ActiveSheet, etc?

"Zurn" wrote:


So I want my workbooks to open first, and directly afterwards make my
menu (= run the code)...


--
Zurn
------------------------------------------------------------------------
Zurn's Profile: http://www.excelforum.com/member.php...o&userid=14645
View this thread: http://www.excelforum.com/showthread...hreadid=532168

This is my code: typed in ThisWorkbook of the VBAProject (Personal.xls)
____________________________________
Private Sub Workbook_Open()
Application.WindowState = xlMaximized
Application.ScreenUpdating = False
Create_Menu
Application.ScreenUpdating = True
End Sub
____________________________________

The Sub Create_Menu goes to the opening workbook and looks into a sheet
of this workbook. But the sub is executed before the book opens, and the
sub does not see the sheet he needs.

Sollution would be a code executed directly after opening, does this
exist?


--
Zurn
------------------------------------------------------------------------
Zurn's Profile: http://www.excelforum.com/member.php...o&userid=14645
View this thread: http://www.excelforum.com/showthread...hreadid=532168

Ok, finally found it!

I should have used: App_WorkbookOpen

because I am working in the application, not the workbook. Stupid me!


Now you know also it


--
Zurn
------------------------------------------------------------------------
Zurn's Profile: http://www.excelforum.com/member.php...o&userid=14645
View this thread: http://www.excelforum.com/showthread...hreadid=532168

Thanks for letting us know

"Zurn" wrote:


Ok, finally found it!

I should have used: App_WorkbookOpen

because I am working in the application, not the workbook. Stupid me!


Now you know also it


--
Zurn
------------------------------------------------------------------------
Zurn's Profile: http://www.excelforum.com/member.php...o&userid=14645
View this thread: http://www.excelforum.com/showthread...hreadid=532168