macros will not assign to buttons

[jcnmilton]

Help! I cannot assign macros to my custom buttons. The dialog box
appears and I can select a macro but it does not save to the button. I
believe this is related to another problem I had - which was my
personal.xls file did not load on start even though it was in the xl
start folder. I fixed that - it was disabled by excel which I fixed by
going to about excel - disabled files and selecting enable. Now
personal.xls loads - but the macros will not assign.

 

[Gord Dibben]

What type of button?

From Tools>Customize>Commands>Macros?

These customizations are stored in a file named Excel(x).xlb where (x) is your
version number.

Could be it is corrupt....frequently happens when too large.

Or your permissions do not allow you to save to that file.

With Excel closed, search for it and re-name to Excelx.old then re-start
Excel. Do your button thing again and see what happens.

Created from the Forms Toolbar?

Right-click on button and "assign macro".

Control Toolbox?

If from the CT, there is no "assign macro" option.

Right-click and "View Code". Enter your code or macro to run here.


Gord Dibben Excel MVP