Associate
- Joined
- 27 Jan 2005
- Posts
- 1,397
- Location
- S. Yorks
Hi,
This has got me stumped.
In excel I have an addin, when this is run copies of sheets are made from the addin and pasted to a new workbook. All was well with this until I tried to run the spreadsheet in office 2010 where any line that copies the sheet from the workbook to the new workbook takes over a minute to complete.
Anyway got around this by copying a range instead of the entire sheet, however one of the sheets in the addin contains buttons and these don't get copied across.
So I have created the required buttons dynamicly, and assign the macro from the addin to the onaction. All should be good apart from when the button is pressed it cannot find the macro to run as it is in the addin not the new worksheet.
How can I get around this?
regards,
Matt
This has got me stumped.
In excel I have an addin, when this is run copies of sheets are made from the addin and pasted to a new workbook. All was well with this until I tried to run the spreadsheet in office 2010 where any line that copies the sheet from the workbook to the new workbook takes over a minute to complete.
Anyway got around this by copying a range instead of the entire sheet, however one of the sheets in the addin contains buttons and these don't get copied across.
So I have created the required buttons dynamicly, and assign the macro from the addin to the onaction. All should be good apart from when the button is pressed it cannot find the macro to run as it is in the addin not the new worksheet.
How can I get around this?
regards,
Matt