Cannot run macro

Hi,

I am facing problem in this file, I am calling macro on clicking button, first button works fine but while clicking on second button it gives error.

"Cannot run the macro 'yogendra1.xlsm!Button_Click'. The macro may not be available in this workbook or the macro might be disabled"

I have already checked macro setting, all macros are enable.

Here what i want do do in my work sheet, I want to archive values from raw sheet to Sheet1 Sheet2 Sheet3 and so on by clicking on button in raw sheet.

Thanks for your help
Aatif.

May be:
right click on 2nd button, Assign macro, select Archivedata2 and click OK.

Hi aatif0712,

Please check the attached macro file.
1) Your first button csv calls function ArchiveData1() in Module1.
2) But your second button calls function Button5_Click which is not available any where in the macro hence it is giving the error.
3) You need to reassign the function on second button click which is available in the .xlsm file.


Regards,
Paresh J