Copy one sheet of macro file into another macro .xlsm file uipath

The problem in copy pasting is that macro file function which is choosing option inside the xlsm file disappears. I’ve tried copy file activity but it didn’t work with xlsm files