Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 48
Default Prevent Tool bar buttons from displayinf

Hi all,

How can I prevent displaying all tool bars (tool bar
buttons)

even after using

Application.CommandBars("Toolbar List").Enabled = False

still toolbar buutons are displayed and enabled?

TIA
Soniya
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Prevent Tool bar buttons from displayinf

That command has nothing to do with whether they display or not.

There are many commandbars - which one are you trying not to display?

Application.CommandBars("Worksheet Menu Bar").enabled = False

might be what you want.

--
Regards,
Tom Ogilvy

Soniya wrote in message
...
Hi all,

How can I prevent displaying all tool bars (tool bar
buttons)

even after using

Application.CommandBars("Toolbar List").Enabled = False

still toolbar buutons are displayed and enabled?

TIA
Soniya



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
How to access macros via tool buttons? Mel[_4_] Excel Discussion (Misc queries) 2 May 27th 10 04:16 PM
How to prevent short cuts from disappearing from tool tips? Dima Excel Discussion (Misc queries) 0 April 15th 09 08:02 AM
How to prevent short cuts from disappearing from tool tips? Dima Setting up and Configuration of Excel 0 April 15th 09 08:02 AM
Tool bar keeps changing back after I add edit buttons MarkusB Excel Discussion (Misc queries) 1 November 30th 07 09:36 PM
Creating Buttons using the Forms Tool bar. MK Excel Worksheet Functions 1 April 4th 07 03:33 AM


All times are GMT +1. The time now is 01:04 AM.

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

About Us

"It's about Microsoft Excel"