Macro Cruncher

viper · Mar 28th, 2002, 02:14 PM

Is there anyway to protect my files on open from my work Excel's Macro Cruncher?

They have what we call the "Macro Cruncher".
Some of my files have been disabled or deleted by this cruncher depending on the type of Macro I use. The cruncher seems to delete any file with userforms added and just disables other macros.

Is there any code I can write to innocculate my spreadsheets?

Just wondering,

Paul-Johnson · Mar 28th, 2002, 05:30 PM

You would have to disable all of the macros via security to protect yourself.

If you have the source code of the cruncher - yo may be able to do something.

Dave Hawley · Mar 29th, 2002, 12:13 AM

Hi Viper

Sounds like your IT department have taken the very easy way out at the inconvenience of everybody else. They couldn't be bothered doing their job efficiently so they get a "Macro Crusher", this way they can sit back and rest assured they are stopping a potential virus be taking a blanket approach.

Jack in the UK · Mar 29th, 2002, 03:53 AM

Im with Dave IT dept need to have a look at their delivery of the system/network..

VBA virus are not so bad.. and i collect virus enfected files to test V Checkers and i can say i have a large collection of macro virus, i guess now almost 60000 diff types bet no more than 25 are macro related, so seem a very sill approach to me. Whats the worst they restore something from backup,, hard life.

To add... its less than fashionable to write macro virus files now, and when you look at some which are extreamly cleaver, bouncing out milluions of emails arround the world all infected, with no distruction but to slow servers as heavy pay loads. im at a loss all very silly.

Programmers that cleaver should jump on this site and HELP people thing what they could show us and all for the good.

I bet somewhere the IT dept had a issue and someone panicked so your where you are now.

All the network needs is FULL daily update Virus protection not local install but local PC point to the server and do as you like down time if you have any nasty virus will be limited to one PC and 30 mins all restored.

Need strong IT dept... look at all i bang on about.. i must haev access somewhere and i am a basic fininace guy?

viper · Mar 30th, 2002, 12:22 AM

Thanks guys,

I agree, one bad apple doesn't spoil the rest of us. But all I have to do is send them the file and they can check it see how it works and add whatever code they have to for it to work properly.

Thanks again,

Jack in the UK · Mar 30th, 2002, 02:19 AM

Yes they should be able to do this OK, the Sware checks the file name of VBA, if on VBA im lead to beleive that its a line entrt they add and its reference to the file name, stops people like me adding this line to all my codes.. which i would and they know it.

kinda of one line one file stuff..

If it were me i would bribe the IT department, which of cause i would not dio my self! cough!

Mar 28th, 2002, 02:14 PM	#1
viper Board Regular Join Date: Feb 2002 Location: Jefferson City, Missouri Posts: 383	Is there anyway to protect my files on open from my work Excel's Macro Cruncher? They have what we call the "Macro Cruncher". Some of my files have been disabled or deleted by this cruncher depending on the type of Macro I use. The cruncher seems to delete any file with userforms added and just disables other macros. Is there any code I can write to innocculate my spreadsheets? Just wondering, __________________ I appreciate the help from everyone at Mr. Excel. viper

Mar 29th, 2002, 03:53 AM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Im with Dave IT dept need to have a look at their delivery of the system/network.. VBA virus are not so bad.. and i collect virus enfected files to test V Checkers and i can say i have a large collection of macro virus, i guess now almost 60000 diff types bet no more than 25 are macro related, so seem a very sill approach to me. Whats the worst they restore something from backup,, hard life. To add... its less than fashionable to write macro virus files now, and when you look at some which are extreamly cleaver, bouncing out milluions of emails arround the world all infected, with no distruction but to slow servers as heavy pay loads. im at a loss all very silly. Programmers that cleaver should jump on this site and HELP people thing what they could show us and all for the good. I bet somewhere the IT dept had a issue and someone panicked so your where you are now. All the network needs is FULL daily update Virus protection not local install but local PC point to the server and do as you like down time if you have any nasty virus will be limited to one PC and 30 mins all restored. Need strong IT dept... look at all i bang on about.. i must haev access somewhere and i am a basic fininace guy? __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Mar 30th, 2002, 12:22 AM	#5
viper Board Regular Join Date: Feb 2002 Location: Jefferson City, Missouri Posts: 383	Thanks guys, I agree, one bad apple doesn't spoil the rest of us. But all I have to do is send them the file and they can check it see how it works and add whatever code they have to for it to work properly. Thanks again, __________________ I appreciate the help from everyone at Mr. Excel. viper

Mar 30th, 2002, 02:19 AM	#6
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Yes they should be able to do this OK, the Sware checks the file name of VBA, if on VBA im lead to beleive that its a line entrt they add and its reference to the file name, stops people like me adding this line to all my codes.. which i would and they know it. kinda of one line one file stuff.. If it were me i would bribe the IT department, which of cause i would not dio my self! cough! __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 05:30 PM	#2
Paul-Johnson New Member Join Date: Feb 2002 Posts: 47	You would have to disable all of the macros via security to protect yourself. If you have the source code of the cruncher - yo may be able to do something.

Mar 29th, 2002, 12:13 AM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Viper Sounds like your IT department have taken the very easy way out at the inconvenience of everybody else. They couldn't be bothered doing their job efficiently so they get a "Macro Crusher", this way they can sit back and rest assured they are stopping a potential virus be taking a blanket approach.