How to save code under VBAProject(PERSONAL.XLSB) that applies to any workbook

Even though I'm saving a code in a new module under VBAProject(PERSONAL.XLSB), it doesn't appear when i try to use it in another workbook. Yes, i'm trying with macro enabled workbooks but it doesn't work out. The code is as follows:

Please Login or Register  to view this content.

I dont know what the problem is.

Do 1 thing, a shortcut if you like. Start recording a Macro using the macro recorder and save it in the Personal Macro Workbook (Just a Dummy Step or 2)

Now enter VBA and open that newly recorded code, delete the code except the Macro name, Copy and Paste your code, and then change the Macro name if you want.


Thank You,

Deep Dave

Hi, bubai,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


The function you have will be listed in the Function Wizard as UserDefined.

Ciao,
Holger

Oops.. Its a Function not a Sub.. Sorry missed it..