Open Excel
Open your workbook
Hit alt-F11 to see the VBE
hit ctrl-r to see the project explorer (like windows explorer)
Find your project in that window.

Expand all the objects in that project.

You'll see a ThisWorkbook object (sometime!).

Doubleclick on that and the righthand side should show you the ThisWorkbook code
window.

At the top of that window, you'll see two dropdowns.

Choose Workbook from the lefthand side dropdown.
If you don't see:
Private Sub Workbook_Open()
in the code window, then use the righthand side dropdown to choose Open.

Debra Dalgliesh explains how to remove remnants of all macros he
http://contextures.com/xlfaqMac.html#NoMacros

But the pictures may be useful to you.


Tim wrote:

A reply to another post said "Open the VBA code page for ThisWorkbook and
enter the following into the Workbook Open function". I have limited
knowledge of programming and could find this function on the VBA page.

How do I put the a line of code into this function?
--
TIA

Tim

--

Dave Peterson