Keeping spellnumber,splitme & sumbold in a one sheet

[vishwajeet_chakravorty]

Sir,
I want to keep spellnumber, splitme and sumbold funtions in one sheets. How can I make it possible to use these funtions in a sheet at a time.

 

[drsarao]

Welcome to MrExcel!
I presume that these are User Defined Functions.
What is it that you want?
Do you want these functions to be available to all the sheets/workbooks?
Or sheets in one particular workbook?
Elaborate please.

 

[vishwajeet_chakravorty]

Thanks for the reply my dear friend. All these functions are user defined funtions. I want all these three funtion, splellnumber, splitme & sumbold should be available in all the worksheets of a perticular workbook.

 

[drsarao]

Excel 2003:
Open the workbook.
Right click on any sheet tab and click "View Code"
On the Visual Basic window which appears, on the left pane look for "VBA Project (yourworkbook.xls)".
Right click on it and then click Insert --> Module
Double click on the now appeared Folder "Module 1"
Now in the right blank pane, paste all the UDFs.
Go back to workbook and save.
Now these functions can be accessed from any of the sheets in yourworkbook.xls.

If you want to make these UDFs available to any open workbook, carry out the above procedure and paste the UDF code into a module in "VBAProject (PERSONAL.xls)"

 

[vishwajeet_chakravorty]

Dear friend, thanks for the solution. I am able to do it now. thanks once again.