Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error while closing Excel
Hi all!
I am using Excel 2002 - SP2 in a W2K SP4. It seems like Excel is trying to compile the code for a worksheet while I am closing Excel. It is giving me a "Method or data member not found" in the line Me.label1.visible = true This line is called during normal operation and it works fine, it seems like the problem may be Excel trying to compile the code after destroying the object label1 while closing. I avoided it by selecting the "Compile on Demand" option, but I don't like it (because the user of my program may deselect it again). Any other ideas? Any help will be appreciated! ====================================== Daniel Altman Buenos Aires, Argentina |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error while closing Excel
Daniel,
Try getting rid of the Me. and replace it with the name of the actual container: Userform1.Label1...... HTH, Bernie Excel MVP "Daniel Altman" wrote in message ... Hi all! I am using Excel 2002 - SP2 in a W2K SP4. It seems like Excel is trying to compile the code for a worksheet while I am closing Excel. It is giving me a "Method or data member not found" in the line Me.label1.visible = true This line is called during normal operation and it works fine, it seems like the problem may be Excel trying to compile the code after destroying the object label1 while closing. I avoided it by selecting the "Compile on Demand" option, but I don't like it (because the user of my program may deselect it again). Any other ideas? Any help will be appreciated! ====================================== Daniel Altman Buenos Aires, Argentina |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error message when opeing and closing excel | Excel Worksheet Functions | |||
Error with closing the Excel file | Excel Discussion (Misc queries) | |||
Error while opening/Closing excel | Excel Discussion (Misc queries) | |||
Error report closing excel | Excel Discussion (Misc queries) | |||
Closing Excel error message from Access 2K | Excel Programming |