Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to switch backgrounds as an indication to the user
of unsaved changes. I want it to skip it if it is going to cause a run time error so I use "on error resume next", but it still errors when there is not enough memory. How do I make it really skip the setbackgroundpicture function if there is not enough memory? On Error Resume Next ThisWorkbook.Worksheets("Data").SetBackgroundPictu re ThisWorkbook.Path & _ Application.PathSeparator & "QPIBackground.jpg" TIA Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
On Error Resume Next problem | Excel Discussion (Misc queries) | |||
On Error Resume Next | Excel Programming | |||
ON ERROR RESUME NEXT | Excel Programming | |||
On Error Resume Next | Excel Programming | |||
On Error Resume Next | Excel Programming |