Share via

Editing Workbook_Open Macro

Anonymous
2019-02-08T13:57:35+00:00

I have a Workbook with a Workbook_Open Macro I need to edit; however, the workbook_Open macro is not visible in my list of Macros nor in view code.  Can you tell me how to access a Workbook_Open Macro to edit it?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2019-02-08T14:36:36+00:00

Hi John,

Press Alt+F11

On the left should be the Project Explorer like the screenshot below. If it is not showing, go under the View menu to display it.

Find the "project" that applies. If this is only one workbook, it is for that workbook. Otherwise it will be in the Personal workbook. Open Modules and then the ThisWorkbook module.

Please let me know if you have any more questions or require further help.

Regards

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest