Here is the code I use to reference the workbook I'm later struggling to open/see.
'Open Pricing Register To Fill Price List And Products With GetObject("Filepath\Pricing Register 2021.xlsm") 'Fill Price List Box PriceList_ComboBox.Clear For Each Cell In .Sheets("Prices").Range("B1:X1") PriceList_ComboBox.AddItem (Cell.Value) Next Cell 'Fill P1 Products P1_ComboBox.Clear For Each Cell In .Sheets("Prices").Range("A7:A52") P1_ComboBox.AddItem (Cell.Value) Next Cell .Close SaveChanges:=False End With
Later I have made a button purely to open this workbook because I was having some trouble:
The code runs without error but won't display the workbook.
However, I can see the sheets, macros etc, for the Pricing Register workbook in the VBA project explorer. It's the same when opening the file directly via the File > Open menu.