Should a new sheet be Macro free

[Jack-P-Winner]

When I open a new sheet I noticed that it has Macros from another sheet are there. Some are blank but the titles are there. I also have a sheet that I track pairs of numbers. When I enter new data to that sheet and rename it ... it wants to pull a totally different book and open it too.

When I open a NEW sheet, should I see other Macros in it?. Why would a newly named sheet cause another sheet to open with it?

This is a new sheet

 

[Deepak]

Hi,

Simply!! new sheets doesn't carry macro itself.

in your screenshot you have displayed some workbooks not worksheets.
Worksheets exists inside Microsoft Excel Objects.




You might need to clarify more.

 

[Jack-P-Winner]

When I open a new sheet I have all these books (projects). When I open some other sheets I have these projects in those too. Does that clarify what I'm asking?

Im not sure how they got attached so to speak