HI,
I have the following VBA code to add a username to a certain cell in column AL if there is any changes has been done in column AA
it was working, but now it seems it is not working, Please helpPlease Login or Register to view this content.
HI,
I have the following VBA code to add a username to a certain cell in column AL if there is any changes has been done in column AA
it was working, but now it seems it is not working, Please helpPlease Login or Register to view this content.
Try this:
Please Login or Register to view this content.
Last edited by berlan; 02-02-2014 at 03:57 PM. Reason: correction: no need to change, your code was running fine
First check if the code is running at all by putting a breakpoint in the code or inserting a BEEP line. If not check the value of Application.EnableEvents. If this is false, change it to true by typing
into the immediate window.Please Login or Register to view this content.
If it is running, then you could try Application.UserName as an alternative to Environ$("USERNAME")
Martin
Your first code works fine for me by the way, perhaps you have turned EnableEvents off after receiving an error?
How do I turn the EnableEvents on
For instance run another macro enabling it.
Please Login or Register to view this content.
Thank you all. It seems there was a small error, I restarted my file and now is is working. But what do I add to the VBA code to restrict is only to column AA and column AL. When I edit a cell in column AB it adds the username in AM, which has a vlookup/hyperlink formula in
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks