initial references of a VBA project

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

I'd like to remove one of these initial references (i.e. Microsoft Calendar Controls 9.0), as it causes problems on some of our client 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érome

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" <jrome.Yacc.1xenya_1130155501.2257@excelforum-nospam.com>
wrote in message
news:jrome.Yacc.1xenya_1130155501.2257@excelforum-nospam.com...
>
> Hello,
> Each time I create a new workbook, the associated VBA project includes
> initial references to some libraries.
>
> I'd like to remove one of these initial references (i.e. Microsoft
> Calendar Controls 9.0), as it causes problems on some of our client
> 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érome
>
>
> --
> jérome Yacc
> ------------------------------------------------------------------------
> jérome Yacc's Profile:
> http://www.excelforum.com/member.php...o&userid=20785
> View this thread: http://www.excelforum.com/showthread...hreadid=478737
>

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" <jrome.Yacc.1xenya_1130155501.2257@excelforum-nospam.com>
wrote in message
news:jrome.Yacc.1xenya_1130155501.2257@excelforum-nospam.com...
>
> Hello,
> Each time I create a new workbook, the associated VBA project includes
> initial references to some libraries.
>
> I'd like to remove one of these initial references (i.e. Microsoft
> Calendar Controls 9.0), as it causes problems on some of our client
> 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érome
>
>
> --
> jérome Yacc
> ------------------------------------------------------------------------
> jérome Yacc's Profile:
> http://www.excelforum.com/member.php...o&userid=20785
> View this thread: http://www.excelforum.com/showthread...hreadid=478737
>

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 Excel application to have modified my Excel initialisation conditions. But it seems that reversing it is not as easy!

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

Jérome

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/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"jérome Yacc" <jrome.Yacc.1xez2b_1130169903.9335@excelforum-nospam.com>
wrote in message
news:jrome.Yacc.1xez2b_1130169903.9335@excelforum-nospam.com...
>
> 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 Excel
> application to have modified my Excel initialisation conditions. But it
> seems that reversing it is not as easy!
>
> I've also made a registry scan, searching for text like "Microsoft
> Calendar Control" but with no success.
>
> Jérome
>
>
> --
> jérome Yacc
> ------------------------------------------------------------------------
> jérome Yacc's Profile:
> http://www.excelforum.com/member.php...o&userid=20785
> View this thread: http://www.excelforum.com/showthread...hreadid=478737
>

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" <jrome.Yacc.1xez2b_1130169903.9335@excelforum-nospam.com>
wrote in message
news:jrome.Yacc.1xez2b_1130169903.9335@excelforum-nospam.com...
>
> 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 Excel
> application to have modified my Excel initialisation conditions. But it
> seems that reversing it is not as easy!
>
> I've also made a registry scan, searching for text like "Microsoft
> Calendar Control" but with no success.
>
> Jérome
>
>
> --
> jérome Yacc
> ------------------------------------------------------------------------
> jérome Yacc's Profile:
> http://www.excelforum.com/member.php...o&userid=20785
> View this thread: http://www.excelforum.com/showthread...hreadid=478737
>