-
Solved: Cant track changes w/ vba - no way!!
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
-
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!)
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
Hello Mdmackillop,
Thanks for letting me know ... not exciting but thats life rite.
Nee
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules