PDA

View Full Version : Solved: Ribbon does not show



evamads
06-15-2009, 05:58 AM
Hi there,

I have made a .xlsm file with a ribbon and saved the file in Excels startup folder (i.e. Excel Options, Advanced "At startup open all files in: C:\ITI\Excel startup")

But the ribbon does not show.:banghead: When I open the file, the ribbon shows, but I want the ribbon til be shows at all times.

Anyone got an idea?

/evamads

Bob Phillips
06-15-2009, 10:29 AM
This suggest that the file is not opening at startup. Are you sure it is in a startup directory?

evamads
06-16-2009, 12:05 AM
Yes, I have copied the path into Excel options, Advanced, 'At startup open all files in'. But it does not open the file or load the ribbon.

evamads
06-16-2009, 12:20 AM
I have tried to rename the file to .xlsb, and now it opens the file, but what I want, is just to load the ribbon (not open the file)

Bob Phillips
06-16-2009, 05:27 AM
You cannot just load the ribbon, the ribbon only gets updated from a file that is opened (except the Excel ribbon tabs of course).

evamads
06-18-2009, 02:16 AM
Hi Xld

Thanks for your ansver. Now I have discovered that if I save the template as an add in (a .xlam file) it works! :) The ribbon loads when I start Excel, and the file does not open.