Two separate modules involved here depending which code you will use.


Right-click on the Excel Icon left of "File" and select "View Code"

The two Workbook subs are to be pasted in there.

If you want to use the CaptionToggle macro instead.................

Hit CTRL + r to open the Project Explorer.

Select your workbook/project by name and InsertModule

Paste the CaptionToggle macro into that General Module.

Save the workbook and hit ALT + Q to go back to Excel.

Close the workbook and re-open.


Gord

On Sat, 1 Jul 2006 13:12:01 -0700, Jim wrote:

Don't know how to access the module to modify it. Have to leave now. Thanks
for the prompt reply.