Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a protected WB and WS with VBA code. If I open it and go to "View code", I need to enter the password. Right. If I Cancel, I get "System error &H80004005 (-2147467259)" and "Undefiend error" message. If I close VBA editor, and try to close Excel, it tell "Cannot quit Excel". The only thing I can do is to end the excel process. There are nothing in call stack. What can I do to be able to end excel normally? Is there any open processes I can't see but that can be ended with VBA on Workbook_Close event maybe? Happy to any suggestions, Tskogstrom |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
With all WSs and WB protected and VBA code password protected, I cannot get
this to happen. Either the WB may be corrupt or your code is running/in break mode at that time. NickHK "tskogstrom" wrote in message ups.com... Hi, I have a protected WB and WS with VBA code. If I open it and go to "View code", I need to enter the password. Right. If I Cancel, I get "System error &H80004005 (-2147467259)" and "Undefiend error" message. If I close VBA editor, and try to close Excel, it tell "Cannot quit Excel". The only thing I can do is to end the excel process. There are nothing in call stack. What can I do to be able to end excel normally? Is there any open processes I can't see but that can be ended with VBA on Workbook_Close event maybe? Happy to any suggestions, Tskogstrom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ACCESS ="NO" BUT EXCEL DISPLAYS "0" | Excel Discussion (Misc queries) | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
Excel will not "show all" from an Advanced Filter on a sheet with protected cells. | Excel Programming |