I am having a problem with macros. I have written a traffic control program (kinda). It simply uses macros to copy and paste pre-drawn graphics of highways. My problem is when I open the program (traffic.xls) and draw some section of road, and then save under a new file name, the next time I open traffic, the macros point to the graphics in the new file. I don't know what I may have done to make this happen, but it is annoying! Can anyone help me?
Delete your current button, then View-->Toolbars-->Control Toolbox and draw a new button. In Edit Mode (the triangle with a pencil), double click and paste your code between the Command Button1_Click() and End Sub.
Thanks for your help, but I am changing how I am doing this program. I am going to use hyperlinks to insert pictures from my custom tool bar and this is working for me. It is a bit slower (I have to redo all of my roads and signs) but all of the hyperlinks work in both the origonal file and the drawn saved one.