| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object Variable with Block variable not set message
I am trying to run this code on workbook open and get the above error message
mode = EssVGetGlobalOption(5) For Each ctl In CommandBars("essoption").Controls If mode = 4 And (ctl.Caption Like "Warnings*") Then ctl.Caption = "Warnings Off" ElseIf mode = 2 And (ctl.Caption Like "Warnings*") Then ctl.Caption = "Warnings On" End If Next ctl the error is on the line For Each ctl In CommandBars("essoption").Controls thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Runtime Error 91 Object variable or With block variable not set. | Excel Programming | |||
| Need help with Error 'object variable or with block variable not set' | Excel Programming | |||
| Getting inconsistent Error 91-Object variable or With block variable not set | Excel Programming | |||
| Run-time error '91': "Object variable or With block variable not set | Excel Programming | |||
| Cells.Find error Object variable or With block variable not set | Excel Programming | |||
Threaded Mode
