View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Calligra[_2_] Calligra[_2_] is offline
external usenet poster
 
Posts: 17
Default Message box causing error in code


Actually no. Book is dimmed as a workbook and it is still a workbook in
the watches window prior to setting it to nothing. I only added that
line of code because I had read that sometimes not setting it to nothing
can cause the Runtime 91 error. If I comment out the message box, the
code runs without error (and remove the extra dims *the whole code used
to be in the lower portion until a later version, but I was getting the
same error as I do now*).
When stepping through the project, it only throws the error when I hit
the "End Sub" of the UserForm_Initialize project. It almost acts as
though the Messagebox is only hiding and not unloaded, but I can't
figure out how to get the message box to actually close.


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!