Hi,
Is there an easy way to copy the entirety of a worksheet (cell content, ActiveX controls in the worksheet, and the macro code associated with that sheet) across to many other worksheets?
I mean manually, not by writing VBA to do it.
[A Cntl A -based copy and paste just seems to copy the cell content - not the ActiveX controls or it's associated handling code].
The ActiveX handling code is all in the individual worksheet module (well, it isn't, but the stub handling code is, and then it re-directs the handling to other code located in a shared (normal) module.
Thanks in anticipation for your advice,
Cheers,
MathUKTeacher
Bookmarks