How do I disable a macro in vb
How do I disable a macro in vb
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks