+ Reply to Thread
Results 1 to 2 of 2

disable a macro

  1. #1
    Forum Contributor
    Join Date
    12-16-2006
    Posts
    349

    Question disable a macro

    How do I disable a macro in vb

  2. #2
    Forum Contributor
    Join Date
    11-29-2003
    Posts
    1,203
    The question is not entirely clear.

    You can set your macro security to medium and not allow any macros to run.

    To kill a single macro:
    + Tools >> Macro >> Macros
    + find the one you want to disable
    + select "Step Into", this opens the VB Editor at the location of the selected macro
    + on the VB Editor tool bar, find the "Reset" button (it is a blue square), and click on it
    + Select the entire macro (starts with "Sub", ends with "End Sub")
    + if you want to delete it permanently, hit the Delete Key; if you only want to turn it off, then open the Edit toolbar (if it is not already visible), and on the Edit toolbar, select the "Comment Block" button. (To make a toolbar visible, use the menu path View >> Toolbars)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1