Forum Discussion

Copper Contributor

Jul 23, 2018

Workbook_Open() fails to open

I built a macro that uses the function Workbook_Open() and then executes stuff which, as I understand it, should kick off as soon as the spreadsheet it opened. I've saved the spreadsheet as .xlsm an...

Macros & VBA

Worksheet_Open

AB_BespokeExcel

Copper Contributor

Jul 17, 2019

Some other ideas;

Make sure the sub is within the "ThisWorkbook" module and called exactly "Private Sub Workbook_Open()". Not in another module, form, worksheet, or class, and obviously on the correct workbook.

"Application.EnableEvents = False" turns off events. If this is ran on another workbook it will stop your workbook from running it's "Workbook_Open". Make sure this is on.

"Workbook_Open" still needs macros to be enabled to run. The trust center options defines how these act but as best practice should be set to always warning. There are further additions from a development end to make sure there is a "splash screen" so the user can not use the tool till macros are enabled if need be.

Hope one of these help?

Alistair Blades - BespokeExcel

JIM SNYDER