LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Call Functions in the Personal Workbook? SteveM Excel Programming 1 December 18th 07 03:07 PM
functions in 'personal.xls' Russ Excel Programming 4 June 28th 07 10:10 PM
PERSONAL.XLS won't take custom functions OxMan Excel Programming 1 August 18th 05 04:08 AM
Custom Functions in Personal.XLS Alan Cannon Excel Programming 2 July 4th 05 01:34 PM
Using functions in personal.xls Lorne[_2_] Excel Programming 1 February 1st 04 08:45 PM


All times are GMT +1. The time now is 07:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"