Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default disable right mouse click on "Worksheet Menu Bar"

HI

I would like to disable the right mouse click on the "Worksheet Menu Bar",
so that you can't add other toolbars such as Standard, Formatting etc..
Unfortunately I couldnt find this in the VBA Help

Hoping someone can help

Max Potters


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default disable right mouse click on "Worksheet Menu Bar"

Hi Max

Try this

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Max Potters" wrote in message ...
HI

I would like to disable the right mouse click on the "Worksheet Menu Bar", so that you can't add other toolbars such as Standard,
Formatting etc.. Unfortunately I couldnt find this in the VBA Help

Hoping someone can help

Max Potters



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default disable right mouse click on "Worksheet Menu Bar"

unfortunately, double-click still is accessible.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ron de Bruin" wrote in message
...
Hi Max

Try this

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Max Potters" wrote in message

...
HI

I would like to disable the right mouse click on the "Worksheet Menu

Bar", so that you can't add other toolbars such as Standard,
Formatting etc.. Unfortunately I couldnt find this in the VBA Help

Hoping someone can help

Max Potters





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
Shortcut to switch from "fill down" to "copy" with mouse drag RJ Dake Excel Discussion (Misc queries) 3 August 13th 09 05:35 PM
How do i disable/enable "Worksheet Move or copy" option? Saon Excel Worksheet Functions 1 May 15th 08 06:30 PM
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F daves Excel Discussion (Misc queries) 3 April 24th 07 04:52 AM
VBA to disable "Delete...." on shortcut menu of worksheet tab? Mary Kathryn Excel Discussion (Misc queries) 3 March 3rd 06 05:54 PM
DISABLE CLOSE MSGBOX ON CLICK "X" sal21[_34_] Excel Programming 1 September 24th 04 03:38 PM


All times are GMT +1. The time now is 05:39 AM.

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"