Cyberdude
10-27-2006, 07:55 PM
I've been having a LOT of trouble with Excel lately (like discovering the presence of over 20,000 invisible (but apparently defined) "LINE"s on my sheet with embedded charts. Had to rebuild that one 'cause I couldn't delete any of the lines. Anyway, today I discovered that three of my most treasured toolbar icons had disappeared, so I've been trying to reconstruct them. My immediate problem is that I can't assign macros resident in Personal.xls to any of the new icons.
I can never remember the names of the (in my case) three toolbars at the top of the Excel screen, but the icons I create usually go on the top two (third one is full). The three I'm trying to create are:
1. Display the Conditional Formatting dialog box.
2. Display the Defined Names dialog box.
3. Display the Paste Special dialog box.
I have a short macro for each function. In addition to having them in Personal.xls, I have them in a couple of other workbooks that I've been testing with. When I try to assign a macro from Personal.xls to a new icon, everything goes smoothly, except the assignment doesn't occur. I even included the full path to Personal as a prefix to the macro name, but when I tried using it, I got a message saying it couldn't be found. Yes, I checked and rechecked the spelling of everything.
When I first started doing this, the macro names in the workbook I was using at the time did take effect, but when I started using the icon with another workbook, then it would open the original workbook to get it (of course). Keep in mind that I have been successfully using the icons that disappeared for years, now I'm having trouble recreating them.
Why don't I just drag the command from the customizing box to the toolbar? Well, I can't find one that displays the Defined Names dialog box. The other two insist of showing a too-long text name that exceeds my available space.
The main question is, why can't I assign a macro that's resident in Personal.xls?? :confused:
I can never remember the names of the (in my case) three toolbars at the top of the Excel screen, but the icons I create usually go on the top two (third one is full). The three I'm trying to create are:
1. Display the Conditional Formatting dialog box.
2. Display the Defined Names dialog box.
3. Display the Paste Special dialog box.
I have a short macro for each function. In addition to having them in Personal.xls, I have them in a couple of other workbooks that I've been testing with. When I try to assign a macro from Personal.xls to a new icon, everything goes smoothly, except the assignment doesn't occur. I even included the full path to Personal as a prefix to the macro name, but when I tried using it, I got a message saying it couldn't be found. Yes, I checked and rechecked the spelling of everything.
When I first started doing this, the macro names in the workbook I was using at the time did take effect, but when I started using the icon with another workbook, then it would open the original workbook to get it (of course). Keep in mind that I have been successfully using the icons that disappeared for years, now I'm having trouble recreating them.
Why don't I just drag the command from the customizing box to the toolbar? Well, I can't find one that displays the Defined Names dialog box. The other two insist of showing a too-long text name that exceeds my available space.
The main question is, why can't I assign a macro that's resident in Personal.xls?? :confused: