I have built a simple quotation system that references a master price list to populate the price fields. The user forms all work as they should, but for some reason, I cannot open the price list workbook anymore. When the macros are running, I can see the file in the VBA project explorer open/close as it should. But when I open the price list directly, I see it download from the server, enable the macros, then a blank grey screen is shown on Excel, even though the file is definitely open in the VBA project explorer.
I have tried a few things so far:
1) Ensure I haven't hidden the file
2) Made a copy, renamed, moved file location etc.
3) Changed my user permissions to have full access
I haven't altered this workbook and only open it once on my user form using the "GetObject" command to retrieve some cell values. I do need to be able to update this workbook as it is the master price list.
Is there a problem with the workbook or the way that I am using it here? This is my first VBA project so still learning a lot!