G
Guest
My customized toolbar with buttons for macros has stopped working.
I have a bunch of macros (10 up to now) for macros on a particular
worksheet. This is a little utility worksheet that is used with a couple of
the macros to pull data off of an application and transfer it to Excel
worksheets. I have all my macros on this utility worksheet, and I created a
toolbar with buttons for 10 of the macros. Everything has been working fine.
If a button was clicked, it automatically opened my utility spreadsheet, and
got the macros from it.
Then, this morning, I had a spreadsheet open, and hadn't yet used any of
these macros, so my utility spreadsheet wasn't open. I went into the Visual
Basic editor to figure something out, and did some saves of different types
of text files.
Now when I click my toolbar buttons, Excel tries to get the macros off one
of the temporary files, and can't find it because it's in a different
directory. Even if it could find it, it doesn't have the macros on it.
I closed Excel completely, and opened the utility file, and it is still
looking for the macros on that temp file, which it can't find. I have tried
creating a new little macro in my utility file, and saving the file, no luck;
I then did a Save As, because that is what I was doing with the temporary
file, but I can't get Excel to start looking for the macros in the utility
file.
Does anybody know a way to get Excel to look in the right place? If it can
be made to look in the wrong place so easily, it should be possible to switch
it back to the right place. The macros are still on the file with the
utility spreadsheet, it's just that the toolbar buttons are mapped to the
wrong place for some reason.
The reason I have my macros on this utility file is that it is on a shared
drive, where the spreadsheets are that I have written the macros for, so they
will be available for all the users of these spreadsheets. So I don't want
to put them in my personal file.
(I wonder how much Microsoft has reduced the life expectancy of the U.S.,
because of the stress of working with its products?)
Thank you.
I have a bunch of macros (10 up to now) for macros on a particular
worksheet. This is a little utility worksheet that is used with a couple of
the macros to pull data off of an application and transfer it to Excel
worksheets. I have all my macros on this utility worksheet, and I created a
toolbar with buttons for 10 of the macros. Everything has been working fine.
If a button was clicked, it automatically opened my utility spreadsheet, and
got the macros from it.
Then, this morning, I had a spreadsheet open, and hadn't yet used any of
these macros, so my utility spreadsheet wasn't open. I went into the Visual
Basic editor to figure something out, and did some saves of different types
of text files.
Now when I click my toolbar buttons, Excel tries to get the macros off one
of the temporary files, and can't find it because it's in a different
directory. Even if it could find it, it doesn't have the macros on it.
I closed Excel completely, and opened the utility file, and it is still
looking for the macros on that temp file, which it can't find. I have tried
creating a new little macro in my utility file, and saving the file, no luck;
I then did a Save As, because that is what I was doing with the temporary
file, but I can't get Excel to start looking for the macros in the utility
file.
Does anybody know a way to get Excel to look in the right place? If it can
be made to look in the wrong place so easily, it should be possible to switch
it back to the right place. The macros are still on the file with the
utility spreadsheet, it's just that the toolbar buttons are mapped to the
wrong place for some reason.
The reason I have my macros on this utility file is that it is on a shared
drive, where the spreadsheets are that I have written the macros for, so they
will be available for all the users of these spreadsheets. So I don't want
to put them in my personal file.
(I wonder how much Microsoft has reduced the life expectancy of the U.S.,
because of the stress of working with its products?)
Thank you.