Macro Cruncher
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Macro Cruncher

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Jefferson City, Missouri
    Posts
    382
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.


  3. #3
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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"

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Jefferson City, Missouri
    Posts
    382
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com