Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Icons/Macros Missing
Platform: Win XP Pro Sp3.
I have tried to permanately set new icons up on toolbars. Icons for Macros which I pull from the "Customise/Macro/ Assign etc" If matters not whether I Unhide/Hide the Personal.Xls, or whether I simply set up in a common sheet, etc. The Icons/Macros work like a charm when installed, then I close, saving etc, saving the Personal.XLS where/if required. Then bingo, when I restart Excel, the Icons/Macros that I have carefully installed, simply are not to be seen. Yes I have accessed as Administrator, just me, or whatever, No luck. What am I doing wrong?? Oh and a Happy Christmas to one and all! Dave. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Icons/Macros Missing
Platform: Win XP Pro Sp3. is your OS
Which version of Excel are you running? Sounds like 2003 to me. Toolbar and Menu customizations in Excel 2003 are saved into a file named Excel11.XLB Normally stored here...... C:\Documents and Settings\username\Application Data\Microsoft\Excel Perhaps this file is not being updated when you close Excel............permissions not allowing?...............file is corrupt, can happen when it gets too large. Close Excel. Find your Excel11.xlb file and note the modified date and size. Open Excel with a new workbook. In Excel make some customizations to Toolbar or Menu. Close Excel..................has the *.xlb file changed at all? You may have more than one...........you may have to muck around with changing names like Excel11.xlb_one or similar. When you get straightened out make sure you save a copy of your latest. To avois using the *.xlb file for customizations it would be best to create toolbars and menus through code in your Personal.xls. See Debra Dalgleish's site for tips and code for that. http://www.contextures.on.ca/xlToolbar02.html Gord Dibben MS Excel MVP On Wed, 23 Dec 2009 02:00:56 GMT, "David" wrote: I have tried to permanately set new icons up on toolbars. Icons for Macros which I pull from the "Customise/Macro/ Assign etc" If matters not whether I Unhide/Hide the Personal.Xls, or whether I simply set up in a common sheet, etc. The Icons/Macros work like a charm when installed, then I close, saving etc, saving the Personal.XLS where/if required. Then bingo, when I restart Excel, the Icons/Macros that I have carefully installed, simply are not to be seen. Yes I have accessed as Administrator, just me, or whatever, No luck. What am I doing wrong?? Oh and a Happy Christmas to one and all! Dave. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Icons/Macros Missing
Gord, thankyou for your reply.
I have looked carefully at the .xlb, it was 16kb 2 years ago and still was16Kb until I wiped it out, restarted at 16kb, changed tools bars, down to 14Kb, but NO the changes to the experimental worksheet did not last. I probably will use your code to set up a floater, but it appears I have a deeper problem as Windows Explorer has been giving me minor probs too. Probably something in permissions/Comodo firewall/AVG - AV, take your pick. Would you care to point me further as I have never been happy with the permissions bit in XP as only myself use my couple of machines. And thankyou again, Dave. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Platform: Win XP Pro Sp3. is your OS Which version of Excel are you running? Sounds like 2003 to me. Toolbar and Menu customizations in Excel 2003 are saved into a file named Excel11.XLB Normally stored here...... C:\Documents and Settings\username\Application Data\Microsoft\Excel Perhaps this file is not being updated when you close Excel............permissions not allowing?...............file is corrupt, can happen when it gets too large. Close Excel. Find your Excel11.xlb file and note the modified date and size. Open Excel with a new workbook. In Excel make some customizations to Toolbar or Menu. Close Excel..................has the *.xlb file changed at all? You may have more than one...........you may have to muck around with changing names like Excel11.xlb_one or similar. When you get straightened out make sure you save a copy of your latest. To avois using the *.xlb file for customizations it would be best to create toolbars and menus through code in your Personal.xls. See Debra Dalgleish's site for tips and code for that. http://www.contextures.on.ca/xlToolbar02.html Gord Dibben MS Excel MVP On Wed, 23 Dec 2009 02:00:56 GMT, "David" wrote: I have tried to permanately set new icons up on toolbars. Icons for Macros which I pull from the "Customise/Macro/ Assign etc" If matters not whether I Unhide/Hide the Personal.Xls, or whether I simply set up in a common sheet, etc. The Icons/Macros work like a charm when installed, then I close, saving etc, saving the Personal.XLS where/if required. Then bingo, when I restart Excel, the Icons/Macros that I have carefully installed, simply are not to be seen. Yes I have accessed as Administrator, just me, or whatever, No luck. What am I doing wrong?? Oh and a Happy Christmas to one and all! Dave. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Icons/Macros Missing
As far as permissions go I can only point you to Windows Help on that
subject. Gord On Thu, 24 Dec 2009 10:02:14 GMT, "David" wrote: Gord, thankyou for your reply. I have looked carefully at the .xlb, it was 16kb 2 years ago and still was16Kb until I wiped it out, restarted at 16kb, changed tools bars, down to 14Kb, but NO the changes to the experimental worksheet did not last. I probably will use your code to set up a floater, but it appears I have a deeper problem as Windows Explorer has been giving me minor probs too. Probably something in permissions/Comodo firewall/AVG - AV, take your pick. Would you care to point me further as I have never been happy with the permissions bit in XP as only myself use my couple of machines. And thankyou again, Dave. "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . Platform: Win XP Pro Sp3. is your OS Which version of Excel are you running? Sounds like 2003 to me. Toolbar and Menu customizations in Excel 2003 are saved into a file named Excel11.XLB Normally stored here...... C:\Documents and Settings\username\Application Data\Microsoft\Excel Perhaps this file is not being updated when you close Excel............permissions not allowing?...............file is corrupt, can happen when it gets too large. Close Excel. Find your Excel11.xlb file and note the modified date and size. Open Excel with a new workbook. In Excel make some customizations to Toolbar or Menu. Close Excel..................has the *.xlb file changed at all? You may have more than one...........you may have to muck around with changing names like Excel11.xlb_one or similar. When you get straightened out make sure you save a copy of your latest. To avois using the *.xlb file for customizations it would be best to create toolbars and menus through code in your Personal.xls. See Debra Dalgleish's site for tips and code for that. http://www.contextures.on.ca/xlToolbar02.html Gord Dibben MS Excel MVP On Wed, 23 Dec 2009 02:00:56 GMT, "David" wrote: I have tried to permanately set new icons up on toolbars. Icons for Macros which I pull from the "Customise/Macro/ Assign etc" If matters not whether I Unhide/Hide the Personal.Xls, or whether I simply set up in a common sheet, etc. The Icons/Macros work like a charm when installed, then I close, saving etc, saving the Personal.XLS where/if required. Then bingo, when I restart Excel, the Icons/Macros that I have carefully installed, simply are not to be seen. Yes I have accessed as Administrator, just me, or whatever, No luck. What am I doing wrong?? Oh and a Happy Christmas to one and all! Dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting ICONS for Macros in Excel 2007 | New Users to Excel | |||
Restore missing Excel icons? | Excel Discussion (Misc queries) | |||
My customized toolbars/macros/Icons disappear. Help! | Excel Programming |