Hi, I have a macro that runs great in 2010. When column 5 says "Closed" the event macro copies the entire row and pastes it in the "Closed" worksheet, it does the same thing when column 5 says Rejected.
When I sent the workbook to a coworker using 2007, nothing happens, no error no nothing.
Anyone have any ideas?
Please Login or Register to view this content.
sounds like your coworker has macros disabled
Josie
if at first you don't succeed try doing it the way your wife told you to
Thats what i thought so i went to him and enabled the macros and still nothing.
Check the current setting of EnabledEvents, maybe it was disabled and not re enabled.
You can use the immediate window
Please Login or Register to view this content.
He had an instance of excel opened, once it was all closed and restarted, it worked fine, sorry for wasting the time of the people that responded
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks