PDA

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



joelle
10-17-2006, 10:50 AM
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
10-17-2006, 02:50 PM
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
10-17-2006, 04:36 PM
Hello Mdmackillop,
Thanks for letting me know ... not exciting but thats life rite.

Nee