View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Craig Craig is offline
external usenet poster
 
Posts: 208
Default functions in personal file

When I create a function procedure in a normal Excel file, I can then insert
it by typing it directly in a cell rather than use the Insert Function
command....yet when I save a function in the Personal.xlsb file to have the
function made available to all Excel files I open, when I type that function
in any Excel file, I have to type : =Personal.xlsb!function name(arguments)
each time....is there a way to avoid having to type the "=Personal.xlsb" part
each time I want to type a function stored in Personal for any Excel file I
want to use it in?

thank you very much for any assistance!!
Craig