how to stop opening of another excel file automatically when running macro

[bhavdip_mangukiya]

I have copied Maco from one file to another file. All works okey, but when i run the macro it automatically open the original file from where it is copied.

how to stop it?

anyone can please help

 

[hajiali]

Please post a copy of the code for your macro.

 

[bhavdip_mangukiya]

There are 8 diffrent modules of macro I'm using
Its just there is a reset but which will change the colour of cells
When I hit it, it just opens up the original file from where it was copied
I have used drag and drop method to copy the sheet from one file to another

 

[bhavdip_mangukiya]

Please post a copy of the code for your macro.

Sub SnipSameSideCornerRectangle6_Click()

Range("B6, B8, B10, B12, B14, B16, D6, D8, D10, D12, D14, D16, F6, F8, F10, F12, F14, F16, H6, H8, H10, H12, H14, H16, J6, J8, J10, J12, J14, J16").Interior.ColorIndex = 33



End Sub

 

[hajiali]

Sub SnipSameSideCornerRectangle6_Click()

Range("B6, B8, B10, B12, B14, B16, D6, D8, D10, D12, D14, D16, F6, F8, F10, F12, F14, F16, H6, H8, H10, H12, H14, H16, J6, J8, J10, J12, J14, J16").Interior.ColorIndex = 33



End Sub

This part of the code does not open any file on my end. look for anywhere in any of your macros for "Workbooks.open......." see example below. in VBA you can use the Find text

Workbooks.open "C:\Users\Dell\Desktop\myFile.xlsx" ' in Quotation should be the file directory here I just put as Directory sample

 

[bhavdip_mangukiya]

This part of the code does not open any file on my end. look for anywhere in any of your macros for "Workbooks.open......." see example below. in VBA you can use the Find text

Workbooks.open "C:\Users\Dell\Desktop\myFile.xlsx" ' in Quotation should be the file directory here I just put as Directory sample

?

 

[bhavdip_mangukiya]

?

i didnt understand,
can you please tell me more about how to find it

 

[hajiali]

In VBA press “CTRL + F” the. Search for “Workbooks.open” you can select entire project see if any results come up