COMPILE ERROR WHEN OPENING WORKBOOK BUT CODE RUNS FINE AFTER CLOSING MESSAGE

[chazrab]

The best way I can explain this is with images below. Listbox1 is on the left, large Textbox3 on the right.
Excel's compile keeps trying to identify Textbox3 as a variable saying its not defined, which of course its not.
Textbox3 is the large textbox. Everything in the code below works great after its in run mode. Its only when
the workbook is closed and reopened does this problem appear. I can't figure it out. This is all on a SHEET, NOT
a userform, But that should make no difference - should it ? Code:

Private Sub Worksheet_Activate()
ListBox1.Visible = True
ListBox1.Height = 337.5
 Me.ListBox1.ListIndex = 0
End Sub

Why is excel trying to recognize Textbox3 highlighted in blue and Listbox1 in yellow as a variable and issuing a Compile error message?
We know its a Textbox object - not a variable.

Something simple I can't figure out.
Please help with this if you see what's happening here .

Thanks for anyone's help.
cr

 

[Domenic]

Does your workbook in fact contain a sheet whose code name is Sheet28 and that contains an ActiveX textbox named TextBox3?

 

[chazrab]

Yes. The images below show that Sheet2 on the tree view and below in the tab section.
The sheet name these objects are on is BIBLETEXT as shown below. From your question, you can see something that's
causing this I don't see. I should be able to open and close this workbook, make changes, save changes, close the workbook
and reopen it without that Compile error being generated - unless I'm missing something that Excel is reading I can't see or find.

Thanks for all your help.