initial references of a VBA project

[jérome Yacc]

Hello,
Each time I create a new workbook, the associated VBA project include
initial references to some libraries.

I'd like to remove one of these initial references (i.e. Microsof
Calendar Controls 9.0), as it causes problems on some of our clien
stations.

I'd appreciate to get some tips for acting on this startup behavior.

I'm working with EXCEL 2000/XP Pro.

Best regards
Jérom

 

[Norman Jones]

Hi jérome Yacc,

Open the default workbook template (Book.xlt) in your XlStart folder,
uncheck the references which are not required and save the file.


---
Regards,
Norman



"jérome Yacc" <[email protected]>
wrote in message
news:[email protected]...

 

[Anne Troy]

The only ones checked for me by default are:
VBA
Excel 9
OLE
Office 9
I'm not a programmer, but my initial reaction is that you've got a template
in your startup that's got (or had) a calendar control in it.
************
Anne Troy
www.OfficeArticles.com

"jérome Yacc" <[email protected]>
wrote in message
news:[email protected]...

 

[jérome Yacc]

Thanks a lot for the answers.

Unfortunately, there is no such Book.xlt in my XlStart directory.

I would be inclined to agree with Anne as I suspect an Exce
application to have modified my Excel initialisation conditions. But i
seems that reversing it is not as easy!

I've also made a registry scan, searching for text like "Microsof
Calendar Control" but with no success.

Jérom

 

[Anne Troy]

Jerome: Do you happen to have an alternate Startup location in your Excel?
In the picture in the article below, it would be listed in the "At
Startup..." box.
http://www.officearticles.com/excel/about_the_xlstart_folder_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"jérome Yacc" <[email protected]>
wrote in message
news:[email protected]...

 

[George Nicholson]

If you don't have a book.xlt file (which is the default, Excel uses it's
built-in template unless the file exists), then you can create one. Just be
sure to remove that reference before you save and any "new" book created
after that point shouldn't have the reference either.

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"jérome Yacc" <[email protected]>
wrote in message
news:[email protected]...