Excel virus?

  • Thread starter Thread starter NZuser
  • Start date Start date
N

NZuser

Hello,
I work with a s/sheet that a few other users have access to, every now and
then really old data seems to come back into the s/sheet - data that had been
deleted from it weeks ago?? How is this possible? How do I check to see if
the s/sheet has a virus?
:-)
 
Hmmm, yes that makes sense! Do you know the macro I can run that gives me the
last user and cells changed?
 
It's not working, I added another w/sheet in the same s/sheet called Usage
then
right clicked on the 'Usage' w/sheet tab, selected 'view code' and pasted in
your code below - is this correct?
 
Wow, thanks!! It's nearly working!!! I did everything you said and it is
automatically hiding the usage worksheet and populating the cells with the
user and date etc when I make a change, the only thing it's not showing is
the actual changes, it's putting in things like $A$4, what does that mean?
 
Ok, thank you so much for your help!! :-)

Simon Lloyd said:
$A$4 will be the cell that was changed, it should show you what the cell
was changed to not what it was, the reason for that is, if you tried to
capture what the cell value was before change your workbook would slow
up as it would be running the code for every cell that was selected.

For further help with it why not join our forums (shown in the link
below) it's completely free, if you do join you will have the
opportunity to add attachmnets to your posts so you can add workbooks to
better illustrate your problems and get help directly with them. Also if
you do join please post in this thread (link found below) so that people
who have been following or helping with this queries can continue to do
so. :)




--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
Click to expand...
 
Back
Top