D
Duncant
Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Some of my macros that worked fine have stopped since I installed the latest security update. I'm now at Excel version 11.5.6 (09028), which has Visual Basic version 11.5 (080416).
As an example, even this simple recorded macro, to copy a text box, generates an error at the "ActiveSheet" line:
Sub Test_copy()
ActiveSheet.Shapes("Text Box 38"
.Select
Selection.Copy
End Sub
Help is much appreciated!
As an example, even this simple recorded macro, to copy a text box, generates an error at the "ActiveSheet" line:
Sub Test_copy()
ActiveSheet.Shapes("Text Box 38"
.Select Selection.Copy
End Sub
Help is much appreciated!