Solved: Cant track changes w/ vba - no way!!

[joelle]

Hello Experts,

I tried to use "track changes" for the huge pricelist that I handle for my
company (course with the purpose of knowing what last messed it up ) but
the msg came back telling I cannot use Track-Changes since the spreadsheet has VBA codes????
It does, and it is a shared file from the server.

So, I tested by creating a simple wb (w/o vba). It now lets me track changes but the option of "list changes in a new ws" is greyed out. I'm obviously lost here, please help.

Nee

[mdmackillop]

Hi Nee,
I don't know about this, but I suspect it's for the same reason that you can't Undo changes performed by a macro (whatever that might be!)

[joelle]

Hello Mdmackillop,
Thanks for letting me know ... not exciting but thats life rite.

Nee