Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 45
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Visual Basic Error Run Time Error, Type Mismatch Meg Partridge Excel Discussion (Misc queries) 12 September 10th 08 06:10 PM
Add CommandBars take long time to return Michael Excel Programming 4 October 23rd 04 05:01 AM
Commandbars Libby Excel Programming 1 August 8th 04 07:11 PM
CommandBars garry Excel Programming 3 June 24th 04 03:12 PM
CommandBars defj Excel Programming 2 November 16th 03 12:57 AM


All times are GMT +1. The time now is 10:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"