Change VBA using VBA??
Results 1 to 2 of 2

Thread: Change VBA using VBA??
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2006
    Location
    Australia
    Posts
    268
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Change VBA using VBA??

    I have a group of users who all have a set of files on their computers... but we've found a bug in one of the macros.

    I'm sending them an 'update' file that will update a bunch of other things in their files - is there a way to also change the macro that is broken??

    eg: I need to add to 'sub insertincentive' the line: Application.Goto Reference:="incentives"

    Thanks!

  2. #2
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    19,672
    Post Thanks / Like
    Mentioned
    14 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Change VBA using VBA??

    Hi

    Chip Pearson explains how to do it here:

    http://www.cpearson.com/excel/vbe.aspx

    I'm assuming the projects are not protected.
    Kind regards
    PGC

    To understand recursion, you must understand recursion.

Some videos you may like

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
  •