Menu

Need to Customize Workbook tabs Context Menu

Search this Thread

Prev

Previous Post

Next Post

Next

#1

Report Post

Posted to microsoft.public.excel.programming

JE McGimpsey JE McGimpsey is offline

JE McGimpsey is offline

external usenet poster

Posts: 4,624

Default

Need to Customize Workbook tabs Context Menu

Try the "Ply" bar

In article .com,
wrote:

Can anyone tell me how to access the Workbook tabs context menu?

I thought I had found the right menu name but when I run the following
code I just get the list of tab names when I thought I would get the
list of context menu items...

Sub Macro1()
Dim i As Integer
Dim x As Integer
Application.CommandBars("Workbook tabs").Reset

With Application.CommandBars("Workbook tabs")
i = .Controls.Count
For x = 1 To i
Debug.Print .Controls(x).Caption
Next
End With
End Sub

I need to prevent the user from changing the structure of the workbook
so I'd like to remove/disable this menu completely if possible.

Kind regards,
Nick.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Context menu of Cell	MadDog	Excel Programming	2	March 4th 06 10:30 AM
Right-Click (Context Menu)	Kryptonix	Excel Programming	6	October 25th 05 03:59 PM
Context Menu	nrussell	Excel Programming	0	September 29th 05 10:08 AM
context menu	eric23	Excel Programming	3	May 9th 04 11:49 PM
Context sensitive menu	Mark[_36_]	Excel Programming	5	March 3rd 04 01:50 PM

All times are GMT +1. The time now is 06:32 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement