Passworded needed to run Saved VBA code

[outlook888]

I added a new macro to an existing sheet (A) which is protected by a password. I then save the existing sheet (A) under a new name (B) and when I try to use the new macro, it asked me for the password to the old existing sheet (A).

How do i make sure that subsequent saved sheet under a new name created from the existing sheet (A) does not require any password to run the new macro. Thank you

[HaHoBe]

Hi, outlook888,

from what I understand from your post (not really get why code must be protected only in one workbook, I would have expected it just to be the other way):

If ThisWorkbook.Name = "EF918592.xlsm" Then
  MsgBox "Here we go for the password"
  'password protection
End If
'run code

Ciao,
Holger

[outlook888]

thank you. I had a look at my codes and realised that they are linked to another sheet which is protected.