buttons for macros not working in 2007

  • Thread starter Thread starter petedavo
  • Start date Start date
P

petedavo

I copy modules over from personal.xls 2003 to personal.xlsb 2007 and they
work if run manually. But the buttons I create for them do not work outside
personal.xlsb
What can I do?
 
Pete?

Why personal.xlsb, why not personal.xlsm? This is the primary Macro-enabled
format. Not sure it will work, but the binary format is for speed of calc
and opening

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk
 
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!
 
Back
Top