Is there a way to include "workbook" event functions in my personal macros file?

Question

e.g.

Private Sub Workbook_AfterSave(ByVal Success As Boolean)
    Beep
End Sub

This only works in "ThisWorkbook," and only in 1 spreadsheet at a time, not in my personal.xlsb file. (Inspired from here.)

Answer 1

1. Press F4 to display project properties.
2. Name the VBAProject for your personal workbook Personal

3. Create a subroutine that calls beep.

   Public Sub MakeItBeep
       Beep
   End Sub
   

4. In the workbook you want to enable this in, click on Tools>>References on the menu bar.
5. Click Browse...
6. Find your Personal.xls file and select it. (It could be in a number of different locations, so searching the C:\ drive is usually the easiest way to go about finding it.)

7. In the proper event of your workbook, insert this code (adjusting for module name of course).

   Personal.Module1.MakeItBeep
   

---

There are a couple of problems with this though, and I really don't recommend it.

1. This is much more code and work than just calling Beep directly.
2. This will most likely cause an error for any other user who works with the workbook. They would need to disable macros on this book. So, if there are any other macros that need to function, you can't do this.

You could use directives to work around that, but it's an awful lot of work for zero benefit. If you're still interested, I wrote a tutorial about how to use conditional compilation with a project level setting.