Inserting a worksheet into another workbook loses its macro in the journey

What am I doing wrong?

Thank you,

Sorry. Didn't think my problem was dependent on the code. Here it is:


Sub Calculate_K()
'
' Calculate_K Macro
'
' Keyboard Shortcut: Ctrl+Shift+K
'
Range("O43").GoalSeek Goal:=0, ChangingCell:=Range("F42")
End Sub

Originally Posted by HaHoBe

Hi, Bill Allen,

kind of hard to tell if you don´t post the code and the extensions of the workbooks involved.

Ciao,
Holger

Are you saying that some worksheets containing macros can be inserted into other workbooks but some cannot due to the specific coding of the macro?

Right. When I insert the worksheet containing the macro into a workbook that I'm building (from templates in my library), I get an error message that reads:
macro.jpg

Right. I try to insert the worksheet with the macro into another workbook and I get this error message:

macro.jpg

Perhaps this is where we are having a communication problem. When I say "copy" a worksheet into another workbook, the way I do this is to have the main workbook open and, when I want to insert the worksheet with the macro in it (or any other of my worksheets from my library), I right mouse click the sheet tab and then select Insert from the pop out menu. At that point, I insert the worksheet with the macro in it into the main workbook. When I do that, the worksheet comes in but the macro cannot be found. Using your test method, I have verified that the macro did not come with the spreadsheet.