I am using a collection of Workbooks that are supposed to work in sync.
When the main "System" Workbook is opened it initializes showing a sequence of userforms which get information from the user to determine how to proceed. One of the options is to "check inventory", when chosen it opens and activates the "Inventory" workbook.
I would like to have the "Inventory" workbook initialize with a userform asking the user if they would like to perform a vlookup or to adjust "quantity on hand".
I have tried to enter code in the "Inventory" workbook's "ThisWorkbook" telling it to show the userform when the workbook opens but it doesn't work when activated through the "System" workbook.
However, if I open the "Inventory" workbook outside of the main "system" workbook (by selecting it from windows file manager) it opens the way I would like it to.
This is what I have used so far
Private Sub Workbook_Open()
Application.EnableEvents = False
Call Auto_OpenInv
End Sub
Sub Auto_OpenInv()
Application.Visible = False 'Hides application while userform is shown
frmInventoryHome.Show vbModal
End Sub
Any Ideas?