Richard U
Active Member
- Joined
- Feb 14, 2006
- Messages
- 406
- Office Version
- 365
- 2016
- 2010
- 2007
- Platform
- Windows
With office 365 on the horizon, I need to catalogue all of our spreadsheets, and identify links.
I am doing this by creating a workbook object, setting the object to"
This works great until I hit a few tools that have Workbook_Open events where the macros start executing.
Is there any way to suppress the events when opening the new workbook?
I am doing this by creating a workbook object, setting the object to"
Code:
Set wb = Workbooks.Open(path & file)
var_Links = wb.LinkSources(xlExcelLinks) 'set variant = excel links
This works great until I hit a few tools that have Workbook_Open events where the macros start executing.
Is there any way to suppress the events when opening the new workbook?