Dear all,

I have vba code that works perfectly. However, more users will use this macro, threfore it would be more user friendly to have it as add-in.

I saved code as .xlam and enableed add-ins and macros, but when I run the code this way I get an error 1004 on line Sheet.Copy After:=ThisWorkbook.Sheets(1).

Your help is highly appreciated.

Please Login or Register  to view this content.
Thank you,

Tanja