Cant run macro on desired sheet

[cuetipper]

New to the board and macros. I have a macro I am running from my personal workbook.
It runs on whatever workbook / worksheet I focus on. But during the process it creates temporary worksheets and it is doing so in the personal workbook. If the sheet is closed the temps stay in the
personal workbook until I close it. I would like for the temp worksheets to be created in the focused workbook and not the personal work book so when I close it they go away.

what code do I need to add?

 

[TheRobRush]

activate the desired workbook in the vba first, and then add the sheet, as shown below

    Workbooks("Book2.xlsx").Activate
    Sheets.Add After:=ActiveSheet

 

[MARK858]

what code do I need to add?

It might help if we saw the code. If the personal workbook is hidden then you shouldn't need to activate the "desired workbook" as it should be the activeworkbook already but can't really tell as we haven't seen your code.

 

[cuetipper]

The code is not complete. And the personal workbookis hidden. So how can I force it to stay fpocused on the aactive workbook.

 

[MARK858]

The code is not complete

Not anything we can tell you unless we see what you have and are doing

 

[TheRobRush]

Not anything we can tell you unless we see what you have and are doing

Yah like Mark said we really need to see the code itself to give you a perfect answer.

 

[cuetipper]

Tks. Will post shortly