Hi there.
I've go an xlsb workbook that that has a single macro button called "Process Data" on it that opens and copies sheet1 from another workbook into a sheet in the xlsb workbook.
The data in this copied sheet is then processed a row at a time, and creates and saves and closes a new workbook for each row.
Once done a message box opens an tells the user how many new worbooks were created, and if there were any rows outstanding on the sheet that could not create a workbook.
What is happening is if the user then attempts to press the "Process Data" button again to run a new input sheet, there is no response from the button unless they click somewhere else on the worksheet first - it looks like Excel thinks I'm trying to edit the button.
I've cleared the cache and activated the orginal workbook, but that doesn't seem to work.
There are multiple modules and macros in this workbook, so I've just included the main macro that the button controls, as well as the macro that creates and saves the individual workbooks.
I've go an xlsb workbook that that has a single macro button called "Process Data" on it that opens and copies sheet1 from another workbook into a sheet in the xlsb workbook.
The data in this copied sheet is then processed a row at a time, and creates and saves and closes a new workbook for each row.
Once done a message box opens an tells the user how many new worbooks were created, and if there were any rows outstanding on the sheet that could not create a workbook.
What is happening is if the user then attempts to press the "Process Data" button again to run a new input sheet, there is no response from the button unless they click somewhere else on the worksheet first - it looks like Excel thinks I'm trying to edit the button.
I've cleared the cache and activated the orginal workbook, but that doesn't seem to work.
There are multiple modules and macros in this workbook, so I've just included the main macro that the button controls, as well as the macro that creates and saves the individual workbooks.