Excel problem - macro virus?

[dral]

Can anyone help, i've got a real pain of a problem at work.

I use some quite complex excel spreadsheets at work for doing contaminant migration modelling and over the last week they've graduallly become unusable.

I have to enter data into the sheet and these boxes (and drop down boxes to alter algorythms) have become password protected. Now my best guess is an excel macro virus but i've had no luck finding one (i've tried the dr solomans and the symantec online scanners so far).

Any ideas, it's really causing me a problem now.

I know bugger all about Excel mate..

Bunny knows a fair bit.. I will ask her now..

[Bunny]

Dral,

I use Excel daily but have never come across this problem.

Sorry I can't help

[Mick429]

Sounds like a similar problem here, Nik.

When I have problems like this, Google often helps. Try searching for "excel password protected virus" and working through some of the entries returned.

[dral]

Oh no. I'm going get one of the sledgehammer soon and see if that fixes it.

Ah, pens and paper they were the good old days......

Thanks anyway guys.

[dral]

Thanks mick, i did try google without much luck.

The IT guy here knew a password to open the protected cell (which the annoying twat wouldn't tell me). Which has given me a temporary fix, he's sure it can't be virsus because the machines are running dr solomans and there's no way a virus would get past that (with it's six month old files) is there

[Mick429]

Originally Posted by dral

Thanks mick, i did try google without much luck.

The IT guy here knew a password to open the protected cell (which the annoying twat wouldn't tell me). Which has given me a temporary fix, he's sure it can't be virsus because the machines are running dr solomans and there's no way a virus would get past that (with it's six month old files) is there

Wait till he goes to the bog and beat the password out of him, mate :evil_mad:

Sounds like IT have made a bit of an up-cock, and are covering their rear ends ...

[dral]

I would but he's the bosses son. To be fair the spreadsheet came from the environment agency, i'd like to know what password he had though, it seemed to be a overide one for excel.

[Mick429]

Originally Posted by dral

I would but he's the bosses son.

OK ... put a bag over your head, then beat it out of him

Originally Posted by dral

i'd like to know what password he had though, it seemed to be a overide one for excel.

One of the options on here, I suspect ...

[dral]

Cheers mick, i'll have read through that tonight.