Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    cincinnati oh
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    macro redundancy (97)

    some of my ssheets have the macros from Personal.xls stored separately, giving me a virus warning when i re-open them. can't find why/how/where they are stored. how can i avoid the redundancies, and is there an easy way to delete whole blocks of redundant macros (just retaining their storage in personal.xls)? thanx.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: macro redundancy (97)

    Macros are stored in so-called modules; you can see these modules in the Visual Basic Editor. Select Tools | Macro | Visual Basic Editor... or type Alt+F11. Then type Ctrl+R to make sure that the Project Explorer is visible. If you expand a workbook, you can see which modules it contains, and you can view the code by double clicking a module.

    One module can contain lots of macros and other Visual Basic code. You can remove an entire module by right-clicking it and selecting Remove <modulename> from the popup menu.

Posting Permissions

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