Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why EXCEL is going into Breakmode and open code window.
Hi,
We have few spreadsheets with User interface to select dates (Combo boxes) In EXCEL 2003. All the other users around the world with the same version working fine except this one user have issue on his 2 machines that the code window appears and the excel went into break/debug mode. I did check marco security, options setting for error handling etc. But nothing work, if he do restart his machine then it work for 2-3 hrs and then back to point 0. Any clue or suggest please.......... -- Malik |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why EXCEL is going into Breakmode and open code window.
Check the options in the Code window (Alt F11 from spreadsheet).
Tools - OPtions - General There are three options for breaking on Error. Make sure all PCs have the same options checked. "Malik" wrote: Hi, We have few spreadsheets with User interface to select dates (Combo boxes) In EXCEL 2003. All the other users around the world with the same version working fine except this one user have issue on his 2 machines that the code window appears and the excel went into break/debug mode. I did check marco security, options setting for error handling etc. But nothing work, if he do restart his machine then it work for 2-3 hrs and then back to point 0. Any clue or suggest please.......... -- Malik |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why EXCEL is going into Breakmode and open code window.
I suspect Joel is right about the user having "Break on all errors" set in
his VBE. He would have to change that since it's a user settings not a workbook setting. OR you could add a password to the VB project (Tools, VBAProject Properties). With a protected project this setting is ignored. That's the better answer for the future. -- Jim "Malik" wrote in message ... | Hi, | | We have few spreadsheets with User interface to select dates (Combo boxes) | In EXCEL 2003. All the other users around the world with the same version | working fine except this one user have issue on his 2 machines that the code | window appears and the excel went into break/debug mode. | | I did check marco security, options setting for error handling etc. But | nothing work, if he do restart his machine then it work for 2-3 hrs and then | back to point 0. | | Any clue or suggest please.......... | -- | Malik |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why EXCEL is going into Breakmode and open code window.
Thanks for the reply. But the setting on their excel is "Break on unhandled
errors". -- Malik "Jim Rech" wrote: I suspect Joel is right about the user having "Break on all errors" set in his VBE. He would have to change that since it's a user settings not a workbook setting. OR you could add a password to the VB project (Tools, VBAProject Properties). With a protected project this setting is ignored. That's the better answer for the future. -- Jim "Malik" wrote in message ... | Hi, | | We have few spreadsheets with User interface to select dates (Combo boxes) | In EXCEL 2003. All the other users around the world with the same version | working fine except this one user have issue on his 2 machines that the code | window appears and the excel went into break/debug mode. | | I did check marco security, options setting for error handling etc. But | nothing work, if he do restart his machine then it work for 2-3 hrs and then | back to point 0. | | Any clue or suggest please.......... | -- | Malik |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why EXCEL is going into Breakmode and open code window.
But the setting on their excel
Now it's "their" but before it was "one user". Check the "one user". If something else is the cause I'm afraid I don't know what it is. -- Jim "Malik" wrote in message ... | Thanks for the reply. But the setting on their excel is "Break on unhandled | errors". | | -- | Malik | | | "Jim Rech" wrote: | | I suspect Joel is right about the user having "Break on all errors" set in | his VBE. He would have to change that since it's a user settings not a | workbook setting. OR you could add a password to the VB project (Tools, | VBAProject Properties). With a protected project this setting is ignored. | That's the better answer for the future. | | -- | Jim | "Malik" wrote in message | ... | | Hi, | | | | We have few spreadsheets with User interface to select dates (Combo boxes) | | In EXCEL 2003. All the other users around the world with the same version | | working fine except this one user have issue on his 2 machines that the | code | | window appears and the excel went into break/debug mode. | | | | I did check marco security, options setting for error handling etc. But | | nothing work, if he do restart his machine then it work for 2-3 hrs and | then | | back to point 0. | | | | Any clue or suggest please.......... | | -- | | Malik | | |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why EXCEL is going into Breakmode and open code window.
Since you do not seem to have a solution yet, try running the code cleaner by
Rob Bovey. Maybe there is something "hidden" that if you just clean the code, it might fix it. http://www.appspro.com/Utilities/CodeCleaner.htm Good luck. -- Thx MSweetG222 "Malik" wrote: Hi, We have few spreadsheets with User interface to select dates (Combo boxes) In EXCEL 2003. All the other users around the world with the same version working fine except this one user have issue on his 2 machines that the code window appears and the excel went into break/debug mode. I did check marco security, options setting for error handling etc. But nothing work, if he do restart his machine then it work for 2-3 hrs and then back to point 0. Any clue or suggest please.......... -- Malik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code to open 3D dialog window | Excel Programming | |||
Macro runs faster when VB code window open | Excel Programming | |||
VBA code to check if another window is open? | Excel Programming | |||
Can't open VBA-Code Window | Excel Programming | |||
VB code to open Print window | Excel Programming |