The two routines, Auto_Open and MaxColB both go in a normal module.

First test MaxColB and ensure it works. You will probably want to change
Worksheets("Sheet1").Range("A1")
to suit.

The Auto_Open routine should run automatically when the file opens and call
MaxColB, assuming your security settings allow macros.

Save the file with macros and reopen, the Msgbox should pop up confirming
all is working. Once it is, comment or remove the Msgbox line.

Regards,
Peter T


"megoodsen" wrote in message
ups.com...
Hi,

thanks for the reply.

I tried to implement this, but when I load the XLS, I get the option to
run the macro but nothing seems to happen.

Maybe I need idiots guide to adding this macro properly to excel?