View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Russ Russ is offline
external usenet poster
 
Posts: 9
Default functions in 'personal.xls'

It is my understanding that any subroutine saved in 'personal.xls'
will be accessible to all open workbooks. Does that also apply to
functions as well?

I have several recorded macros in the 'personal.xls' workbook and am
able to exceture them via shortcut keys from any other workbook,
however functions I manually define in the VB editior don't seem to be
accessible outside 'personal.xls'.

Is there some whay I can make functions globally available to all open
workbooks?

Thanks,
Russ