View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jonathan Rynd Jonathan Rynd is offline
external usenet poster
 
Posts: 15
Default Compile error when closing excel

kakou wrote in news:kakou.11u280
@excelforum-nospam.com:

The problem happens when
I close the workbook: I get a compile error stating that the textbox
that I am enabling/disabling does not exist.


What version of Excel are you using?

Old versions had a habit of putting extra cruft into the VB portion of the
workbook that could make things go weird.

The only solution is to rebuild the workbook from scratch. (You can copy
over pieces, of course.)

--
My email address has an extra @ (spell it out) and an extra invalid. Please
remove them if you are not a spammer or list broker and want to reply.