ExcelBanter - run time error on commandbars

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - run time error on commandbars (https://www.excelbanter.com/excel-programming/314467-run-time-error-commandbars.html)

tango

run time error on commandbars

i have this statement reads

password correct -
CommandBars("test toolbar").visible = true

workbook open/close
CommandBars("test toolbar").visible = false

the above can work when i test on a new workbook but have this message
run time error 91
object variable or with block variable not set

why?

Frank Kabel

run time error on commandbars

Duplicate

--
Regards
Frank Kabel
Frankfurt, Germany

"tango" schrieb im Newsbeitrag
m...
i have this statement reads

password correct -
CommandBars("test toolbar").visible = true

workbook open/close
CommandBars("test toolbar").visible = false

the above can work when i test on a new workbook but have this
message
run time error 91
object variable or with block variable not set

why?

All times are GMT +1. The time now is 05:24 PM.