Making My Macros Stick.
Making My Macros Stick.
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Making My Macros Stick.

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    How do I ensure that when I do a 'Save As' on my worksheet, all the associated macros will be bound with it?

    At the moment, every time I 'Save As' and then press a tool button to activate one of my macros, I get either an error message staing that the path cannot be found or the original worksheet opens and the macro is executed on the original copy.

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is the toolbar with your macros attached to the original sheet?

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes it is.

  4. #4
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Well then the macro is still looking for the original workbook. Do you want the toolbar button to open up a workbook and then run the macro or is the workbook already open?

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Well then the macro is still looking for the original workbook. Do you want the toolbar button to open up a workbook and then run the macro or is the workbook already open?
    The toolbar button is to activate administrator options within this workbook. The toolbar is only loaded when this workbook (or any saved instances) are opened. The toolbar is then disabled when the workbook is closed.

  6. #6
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sounds like the macro buttons are still pointing to the original workbook. Check to see the path...right click on a toolbar, goto customize, then activate the actual toolbar by clicking on it, then right click the buttons in question, goto assign macro, and check the path, delete the file path and just leave the macro name.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sounds like the macro buttons are still pointing to the original workbook. Check to see the path...right click on a toolbar, goto customize, then activate the actual toolbar by clicking on it, then right click the buttons in question, goto assign macro, and check the path, delete the file path and just leave the macro name.
    I keep doing this, but every time I do a 'Save As' the paths don't go with the sheet. It's beginning to get my goat having to keep reassigning the macro commands.

  8. #8
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Nick

    Are you just disabling the Toolbar or Deleting it? If the Toolbar IS attached to the Workbook it may need to be Deleted on Closing. This is a better way alround for attached toolbars.




  9. #9
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm just disabling them at the moment. I'll change it to delete and see how that works.

    Cheers.

  10. #10
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Yahoo!!

    Cheers Dave, that's done it.


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
  •  

 

 
DMCA.com