Please recommend a method

[Fredy]

I have built a worksheet that contians control textboxes
and checkboxes. There is vb code that references these
objects, but when the file is renamed, it crashes because
of the name change. If I change to a template, Windows
appends a (1) when I open the file, so same problem. Can
anyone suggest how i should distibute this to minimize the
chance of a user breaking it while remaining functional?
Any help is greatly appreciated. thanks.

 

[Tom Ogilvy]

the predefined variable/reference ThisWorkbook refers to the workbook
containing the code. Instead of using the workbook name, use ThisWorkbook

workbooks("Mybook.xls").Worksheets("Sheet1").Range("A1").Value = 10

would be
ThisWorkbook.Worksheets("Sheet1").Range("A1").Value = 10

 

[Fredy]

Thank you , thank you! Great help. Thanks for taking the
time to help the rest of us.