Personal.XLSB procedure to run in any project

Hello Everyone

I think that I am having trouble with permissions here. I have VBA code that I have stored in my Personal.xlsb. this code though need to be able to run on any workbook that i load up. If i copy the Sub procedure into the Associated Workbook Project i can get it to work, but it will not run when it is just in my Personal.XLSB project. Therefore how can i run a Sub from my personal Project that runs on any project (workbook) that i load up.

It used to work but i have changed laptop and the above is the problem i am now experiencing.

can anyone help please

Thanks
Jaimie

What is the actual problem you are having? i.e. what specifically do you mean when you say it will not run?

The error is because you haven't declared x as a variable.

Why have the code in a PERSONAL workbook, but aim it at a specific workbook, you may as well have the code in that workbook

Do you have a sub called x in your personal workbook?

Presumably then you have

Option Explicit

at the top of your module in the Personal.xlsb workbook, and you don't in the other workbook.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

I think too much time has passed. Don't worry, I've done it for you.