Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Disable Macro Function

    Word 2000 SR2

    We would like to prevent the users from creating macros. Is there a way to disable the macro feature.

    Any help would be greatly appreciated.

    Yes, I know its harsh.

    pife

  2. #2
    BAM
    Guest

    Re: Disable Macro Function

    Okay, I'll take the bait... <g>

    Why would you want to disable one of the most valuable Word tools?

    Wouldn't you rather let them speed up processes and get more work accomplished in a fraction of the time?

  3. #3
    New Lounger
    Join Date
    Jan 2001
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable Macro Function

    We have provided them with macros at least 80 of them. Which are on the network. Higher ups want standard normal.dot and tech dept. to be the only ones to develop and maintain macros.

  4. #4
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Oregon, USA
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable Macro Function

    Hi Pife,

    Is it that the mucky-mucks don't want folks editing the macros you've already provided or they don't want folks creating macros at all? If it's the former, you can use network permissions to prevent users from editing the templates.

    Chris

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable Macro Function

    Create these Subs in a read-only global template that starts with Word (or in each user's Normal.dot - which I do not advise, but everyone knows that by now...)

    Sub ToolsMacroRecordStart
    end sub

    Sub ToolsMacro
    end sub
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  6. #6
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Oregon, USA
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable Macro Function

    Hi Kevin,

    Just outta curiosity, any ideas on how to hijack Alt+F11?

    Regards,

    Chris

  7. #7
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Oregon, USA
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable Macro Function

    Very cool. Glad I didn't test this stuff in Normal. <g>

  8. #8
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable Macro Function

    Chris,

    Sure.

    One more "disabling" Sub

    Sub ViewVBCode
    end sub
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  9. #9
    New Lounger
    Join Date
    Jan 2001
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable Macro Function

    Don't want them to create their own. The network templates are protected arleady

  10. #10
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Disable Macro Function

    Also might want to throw this one in there:

    Application.ShowVisualBasicEditor = False

  11. #11
    New Lounger
    Join Date
    Jan 2001
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable Macro Function

    Kevin,

    You wouldn't have the code to prevent changing the normal.dot

    Thanks alot for your help with the previous reply.

    Pife

  12. #12
    crudd
    Guest

    Re: Disable Macro Function

    You really dont want to lock them out of normal.dot, thats where all their local environmental settings are kept.

    You are better off providing all your template baggage in your own template, and leaving normal.dot for the user to stuff up and delete whenever they feel like it - which is usually fairly regularly :-)

    If you MUST do it this way, the ole file system privledges is still the best way to go - read only access, and lock their id out of update/modify access etc.

  13. #13
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Disable Macro Function

    Oh, this is evil. As an end-user, I would be most unhappy. I might have to go into the Organizer and get rid of them (assuming they are not in a global template). Would not want to work in a company where someone sophisticated enough to write macros was not allowed to do so.

  14. #14
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Disable Macro Function

    Hi pife,

    Along the lines of the comments from BAM, ChrisGreen and jscher, I was just wondering if there was a specific incident or specific user who triggered this harsh crackdown - is there a really juicy war story here that you're willing to share?

    I can really understand the problems that can be caused by rogue macro users, and understand why network folks want to crack down on it. On the other hand, I never would have gotten started if I'd have been locked out of creating macros, and it's fair to say I ended up creating a fair bit of value for my firm along the way.

    If it's one or more rogue users who are ruining things for everybody, wouldn't some reeducation pressure applied to these individuals be a more appropriate strategy than locking everybody out of the macro recorder? (not to mention that these individuals actually might have ideas that could add value for your firm <g>)

    Gary

  15. #15
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable Macro Function

    > Is there a way to disable the macro feature.


    I weep.

Page 1 of 2 12 LastLast

Posting Permissions

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