I have a file that is in a SharePoint folder and when opened from the Excel application the workbook_open code doesn't execute.
When the file is open I can open the VBE and manually run it (F5 form within the code) but why won't this execute upon opening?
When opened, if the yellow bar pops up about macros, enable content, etc I have clicked to allow.....
The Workbook_open is place in the ThisWorkbook module/object and as above, it can be executed manually via the F5 key press.
TIA
When the file is open I can open the VBE and manually run it (F5 form within the code) but why won't this execute upon opening?
When opened, if the yellow bar pops up about macros, enable content, etc I have clicked to allow.....
The Workbook_open is place in the ThisWorkbook module/object and as above, it can be executed manually via the F5 key press.
TIA
