Running macro from personal.xlsb not working

Hi -

So the other day I received help through the Forum to create a macro. The macro works perfectly when it is stored in the workbook. What I want to do now is store this macro in my Personal.xlsb. So I first copied the macro, I then removed it completely from my active workbook and, three... pasted it in my Personal.xlsb module. However, when I run the macro from my Personal.xlsb I get a 'Variable not defined' error for Sheet1???

Why is this happening?

Please Login or Register  to view this content.

Sheet1 is the codename of a worksheet in the workbook you're intending to process. The name is out of scope in Personal.

You could use

Please Login or Register  to view this content.

EDIT: thanks for fixing the code tags.