View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default personal.xls and add-in

It's probably better to distribute and maintain/update an addin.

There are some small differences in the VBIDE object model in Excel97, but
in Excel 2000-2007 it's the same for all versions, AFAIK.

Since 2002/XP you need to check "Trust access to VB Project"

Regards,
Peter T

"JJF" wrote in message
...
I need to insert on personal.xls of 4 computers 3 routines, that need
maintenance often.

is it possible to use a file (i.e. an add.in that i use for personal
menu) to do it?

i can also remove all module.bas and replace them

i tried with appilcation.vbaprojects compomnents a s idid in the past
but on office xp must be different syntax.