Personal Macro behaves differently??

Hi there,

I encountered something strange recently. 

I have few lines of macro for adding name to a cell on multiple worksheets.  It worked fine.  Then I copied the codes to my Personal Macro for future use.  However when I run the same codes in my Personal Macro, it did not work...

The codes worked again when I put it back to a workbook's modules.  How would that be? 

I am so confused.  Appreciate your advice on it.  

Thanks. :)