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