I didn't know that there aere different personal. file types.
I resaved the personal file as xlsm in the xlstart folder and deleted the
xlsb file
However when I restarted excel and oppenned one of the files from work that
I'm supposed to be working on this weekend it came up with the same error
message as before: Cannot run the macro 'macroname'. The macro may not be
available in this workbook or all macros may be disabled
I looked at
http://support.microsoft.com/kb/930076/en-us but it doesn't fix
my problem
I can run the macros fine, manually from Alt+F8 but this defeats the whole
purpose of having the macros in the first place (saves time).
If I unhide personal.xlsb the buttons then work, but there is good reason
for personal.xlsb to be hidden as I open 30 spreadsheets at a time and use
the macros to copy and past from these locked spreadsheets certain rows and
columns and then paste the values only into a master spreadsheet, and I don't
want to accidently paste something into personal.xlsb or in some other way
accidently copy from it either.
In 2003 this isn't an issue, buttons work fine. In 2007 however they don't
want to work!