Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-31-2016, 05:10 PM
slouw slouw is offline Function not available from personal.xlsb Windows 7 64bit Function not available from personal.xlsb Office 2010 64bit
Novice
Function not available from personal.xlsb
 
Join Date: Mar 2016
Posts: 4
slouw is on a distinguished road
Default Function not available from personal.xlsb

Hi there
when I create a public function and define it in a module within a spreadsheet.xlsm I can access it as a formula from within that spreadsheet.
However if I move that same function to the personal.xlsb spreadsheet then it is no longer accessible. I have many macros defined in personal.xlsb which are available to me from any spreadsheet I open.
How can i make functions defined in persnal.xlsb available to any spreadsheet I open?

Many thanks for any reply
Reply With Quote
 

Tags
function personal missing



Similar Threads
Thread Thread Starter Forum Replies Last Post
Function not available from personal.xlsb Restrict Editing function disable insert textbox function IanM_01 Word 5 11-21-2015 02:29 AM
Function not available from personal.xlsb Error message opening xlsb file in Excel 2008 for Mac Bryce Excel 1 07-27-2014 09:35 AM
Function not available from personal.xlsb #REF! Error in calling VBA function disappears when function is copied lcaretto Excel Programming 2 05-26-2014 07:19 PM
Creating a graph for Future Value function (FV function) bmoody Excel 2 11-06-2013 10:52 AM
Visibility of macros in PERSONAL.XLSB Dougiel Excel 0 05-24-2012 12:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft