Vanishing VB

When I opened a spreadsheet today, all of the VB code was gone. The
spreadsheet is for the month of August, is used daily, and contains (or used
to contain) about half a dozen macros, including _Open and _BeforePrint
entries. They were all there on Friday.

I'm certain the daily users are not knowledgeable enough to remove the code
(I have the individual worksheets locked, but nothing else), and it seems
highly unlikely they could have done it by accident. A friend of mine
suggested virus software might have been run over the weekend. But the
spreadsheet is in the same folder as all of the spreadsheets for previous
months, and all of the code is still in those spreadsheets. So it doesn't
seem like virus software would have singled out this one spreadsheet.

I'm baffled. Any ideas?

--
Bill @ UAMS

Just guesses...

Any chance any user got a warning that excel opened the file with errors and was
able to recover the file--but macros (and possibly formatting) may have been
lost?

Even though protecting the project won't stop the really determined, it will
stop most.

Inside the VBE:
tools|VBAProject Properties|Protection Tab
Lock it for viewing and give it a memorable password.

Very, very, very rarely: I've seen posts that say macros were stripped out by
the antivirus software itself. I've never seen that in real life, though.



BillCPA wrote:

When I opened a spreadsheet today, all of the VB code was gone. The
spreadsheet is for the month of August, is used daily, and contains (or used
to contain) about half a dozen macros, including _Open and _BeforePrint
entries. They were all there on Friday.

I'm certain the daily users are not knowledgeable enough to remove the code
(I have the individual worksheets locked, but nothing else), and it seems
highly unlikely they could have done it by accident. A friend of mine
suggested virus software might have been run over the weekend. But the
spreadsheet is in the same folder as all of the spreadsheets for previous
months, and all of the code is still in those spreadsheets. So it doesn't
seem like virus software would have singled out this one spreadsheet.

I'm baffled. Any ideas?

--
Bill @ UAMS

--

Dave Peterson

The user got an error message yesterday (Monday) when she open the
spreadsheet. She doesn't remember what the message was, but she 'recovered'
the spreadsheet. She wasn't, however, the one who last used the spreadsheet
on Friday. I have asked her to check with the last Friday user to see if
something unusual happened.

They really don't do anything except open the spreadsheet, input data, maybe
do a search (using a macro) for something specific, print, and close. My
guess would be that somehow the machine went off with the spreadsheet still
open. Is it common (or at least 'not uncommmon') when you 'recover' a
spreadsheet that the macros don't come back?

Bill @ UAMS


"Dave Peterson" wrote:

Just guesses...

Any chance any user got a warning that excel opened the file with errors and was
able to recover the file--but macros (and possibly formatting) may have been
lost?

Even though protecting the project won't stop the really determined, it will
stop most.

Inside the VBE:
tools|VBAProject Properties|Protection Tab
Lock it for viewing and give it a memorable password.

Very, very, very rarely: I've seen posts that say macros were stripped out by
the antivirus software itself. I've never seen that in real life, though.



BillCPA wrote:

When I opened a spreadsheet today, all of the VB code was gone. The
spreadsheet is for the month of August, is used daily, and contains (or used
to contain) about half a dozen macros, including _Open and _BeforePrint
entries. They were all there on Friday.

I'm certain the daily users are not knowledgeable enough to remove the code
(I have the individual worksheets locked, but nothing else), and it seems
highly unlikely they could have done it by accident. A friend of mine
suggested virus software might have been run over the weekend. But the
spreadsheet is in the same folder as all of the spreadsheets for previous
months, and all of the code is still in those spreadsheets. So it doesn't
seem like virus software would have singled out this one spreadsheet.

I'm baffled. Any ideas?

--
Bill @ UAMS

--

Dave Peterson

I'm not sure if it's common, but I've seen it happen.

I'd put my money on the user who ignored the "recovered" message.



BillCPA wrote:

The user got an error message yesterday (Monday) when she open the
spreadsheet. She doesn't remember what the message was, but she 'recovered'
the spreadsheet. She wasn't, however, the one who last used the spreadsheet
on Friday. I have asked her to check with the last Friday user to see if
something unusual happened.

They really don't do anything except open the spreadsheet, input data, maybe
do a search (using a macro) for something specific, print, and close. My
guess would be that somehow the machine went off with the spreadsheet still
open. Is it common (or at least 'not uncommmon') when you 'recover' a
spreadsheet that the macros don't come back?

Bill @ UAMS

"Dave Peterson" wrote:

Just guesses...

Any chance any user got a warning that excel opened the file with errors and was
able to recover the file--but macros (and possibly formatting) may have been
lost?

Even though protecting the project won't stop the really determined, it will
stop most.

Inside the VBE:
tools|VBAProject Properties|Protection Tab
Lock it for viewing and give it a memorable password.

Very, very, very rarely: I've seen posts that say macros were stripped out by
the antivirus software itself. I've never seen that in real life, though.



BillCPA wrote:

When I opened a spreadsheet today, all of the VB code was gone. The
spreadsheet is for the month of August, is used daily, and contains (or used
to contain) about half a dozen macros, including _Open and _BeforePrint
entries. They were all there on Friday.

I'm certain the daily users are not knowledgeable enough to remove the code
(I have the individual worksheets locked, but nothing else), and it seems
highly unlikely they could have done it by accident. A friend of mine
suggested virus software might have been run over the weekend. But the
spreadsheet is in the same folder as all of the spreadsheets for previous
months, and all of the code is still in those spreadsheets. So it doesn't
seem like virus software would have singled out this one spreadsheet.

I'm baffled. Any ideas?

--
Bill @ UAMS

--

Dave Peterson



--

Dave Peterson