View Single Post
 
Old 08-25-2015, 11:26 AM
RoMu RoMu is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Mar 2014
Posts: 6
RoMu is on a distinguished road
Default Commanbar not visible at Excelstart

Using Office 2013 in Win7.
Have created a macro that creates a personal commandbar containing several commandbuttons each of them linking to a macro. The individual commandbar is supposed to be visible at the Add-Ins section.
Have set the creation of the commandbar to the event of opening the file.
This file is located in the correct xlstart folder and is set to be hidden.
It automatically opens once exel is started up.

But when excel starts up the created commandbar is not visible at all, although excel seems to go through the right part of the code (as a test-msgbox within this code is being brought up). Closing the file and opening it manually shows the commandbar without any error message.

Are there any restrictions regarding commandbars when excel opens a file through the xlstart folder.

All hints welcome.

Thanks
Rolf
Reply With Quote