vic
10-29-2007, 09:59 AM
I have an excel (version 2002) file in which I have created a number of macros. I have also created a toolbar that contains buttons that execute some of these macros. However, I have discovered a problem which appears to be triggered when I have the workbook open and then choose to save it using a different name. When I close excel and try to open the original workbook once again, the macro buttons in the tool bar, when clicked, seem to want to open up the the renamed excel file that I saved a few moments ago. The macros by the way, cause excel to jump to a different worksheet in the workbook a either hide or display certain columns.
I originally had the toolbars attached to the excel workbook, but I have since detached them to see if this had any effect, but i still have the same problem. Does anyone know why the macro buttons in the original version of the file now want to access the renamed file, and also what I can do to get around this. The reason I ask is that the workbook can be sent to other users who may choose to rename the file.
I originally had the toolbars attached to the excel workbook, but I have since detached them to see if this had any effect, but i still have the same problem. Does anyone know why the macro buttons in the original version of the file now want to access the renamed file, and also what I can do to get around this. The reason I ask is that the workbook can be sent to other users who may choose to rename the file.