importing VBA Macros into new Book - Help!

[SNA400]

Hi all

I have a wierd one here for you to get your teeth into

I need to import 6 macros written in VBA into a new book, but when I follow the usual instructions (developer - copy code - insert module - etc) and save everything when I open up the new book the Macros cannot be seen.


I have imported modules before like this and had no issues, so this is really confusing me!

Does anyone have any ideas??


Simon

 

[MandeepBaluja]

Have you save the file in XLSM format ?? or in some other format ?

 

[SNA400]

Hi

I always save the files as Macro enabled (xlsm) so it's not that little quirk!

i Dont really fancy typing all that code again!

Simon

 

[MandeepBaluja]

provide both files