How do I rename a VBA workbook and get it to work independently from the original?

Hi everyone,

I'm a total newbie to VBA an I've encountered a problem when renaming a VBA workbook.

When I rename the work, I change nothing to code or to the work, I simply want to rename the workbook. The problem I have is that when I rename it, I cannot get it to work independently from the original workbook.

For example, my VBA was written in a workbook called 'original'. I now want to change the name of this workbook to 'new'. However, when I open new workbook and the code runs, the 'original' workbook will open - I'm assuming because it is accessing the code from that.

This is the code I have:

Please Login or Register  to view this content.

Any thoughts, ideas and help on how I can simply rename my workbook and get it to work independently would be greatly appreciated.

Many thanks in advance!

Hey, that's correct.

When I change the Cell in "B14", the macros runs, but via the OriginalBook, despite the NewBook having the exact same code

The macros has been saved in the OriginalWork, which was saved on my desktop. The NewBook is simply a copy/paste version of my original, again saved on my desktop.

I have renamed VBA workbooks in the past and there was never an issue. I think the problem now is that I am calling up modules - something which I've never done before. ..

The macros has been saved in the OriginalWork, which was saved on my desktop. The NewBook is simply a copy/paste version of my original, again saved on my desktop.

I have renamed VBA workbooks in the past and there was never an issue. I think the problem now is that I am calling up modules - something which I've never done before. ..

oops, sorry about that - ignore the last message.

I can't seem to find the attachment link on this...I think I'm being a bit blind. How do I go about attaching workbooks in this forum?

oooo...sorry, I've seen what the problem is. The macros module's are in fact saved in the original workbook. Is there a way I can copy those modules into the copied workbork?

Actually, I'm sorry, the macros are saved in the workbook. The problem has not been solved. Any further help would be much appreciated...

Found the fix. I had 'Application.Run "OriginalBook.xlsm'!AppearSOP"' in the copied workbook. I just had to change that to NewBook.

Thank you anyway for the help Nathan, much appreciate it!