Macro In .xlt File Won't Work In .xls File?

[marshman99ca]

This file is initially saved as a template (.xlt) file. This code works if I right-click and open the template and enter data, but when I just double click and open, causing it to open as an .xls file, it doesn't work. (The textboxes are inserted textboxes not from a userform).

VBA:
 Option Explicit 
 
Sub Text_Copy() 
   With Worksheets("Description") Worksheets("Summary").Shapes("TextBox3").TextFrame.Characters.Text = .Shapes("TextBox1").TextFrame.Characters.Text & " " & .Shapes("TextBox2").TextFrame.Characters.Text 
   End With 
End Sub 

I appreciate any help.

[Aussiebear]

Hi Marshman99ca,

Please post your book so we can see the whole issue.

[Carl A]

This has been Cross Posted here.
http://www.ozgrid.com/forum/showthread.php?t=67612

[Aussiebear]

and cross asked here too...

http://vbaexpress.com/forum/showthread.php?t=12450

Still there's hope that by posting the workbook we can get around this issue.

[marshman99ca]

I am new to these forums, but I have the feeling that this is a bad thing?? I was unaware. In future I will only post on one forum.

[Aussiebear]

That's okay, it's not a hanging offence (so I've been told). If you refer to your other thread I think you might have an answer. When i copied your code to a module I immediately got a "Syntax" error on the With Worksheets line.

[marshman99ca]

Thank you AussieBear, I have been travelling all day and am just getting back to this now and I do see another reply on Mrexcel.com.
I need to get good, really good, at Excel and VBA so we'll be chatting in the future.