Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Jim at Eagle wrote:
The problem is the error trap. If the workbook is started in xlMaximized then a error occurs. I added WindowState = xlNormal to solve this problem (it's commented out here just to crash the code on my machine for testing purpose). However the code still fails on some computers. So I want to eliminate all window size resize functionality from the procedures. I thought an error operation would do this, but it doesn't work. My computer handles quite nicely but Franks don't. I don't want to remove my uncle from my universe. In the VBE go to Tools | Options and on the General tab, ensure that Error Trapping is set to Break on Unhandled Errors. Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error of slope taking into account error of the data points | Excel Worksheet Functions | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming |