How do I "grey" the cut and copy icon in the standard toolba

gandalf

New Member
Joined
Jul 15, 2002
Messages
41
I know how to "grey" the save button in the standard toolbar:
Private Sub Workbook_Open
Application.CommandBars("Standard").FindControl(Id:=3).Enabled = False
End Sub

What are the Id-numbers for the cut & copy buttons?

Thanks in advance.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

dk

MrExcel MVP
Joined
Feb 15, 2002
Messages
2,942
Additionally, the ID of Cut is 21 and Copy is 19. I used this code to find these:-

Code:
Sub ListControls()
Dim r As Long
r = 1

For Each ctl In Application.CommandBars.FindControl(ID:=30003).Controls 'Edit menu
    Cells(r, 1) = ctl.Caption
    Cells(r, 2) = ctl.ID
    r = r + 1
Next ctl
    
End Sub
 

gandalf

New Member
Joined
Jul 15, 2002
Messages
41
Thanks both for the VERY QUICK reply.

Andrew, I already used this code with a bunch of other codes. It desables the paste button but the buttons for cut and copy are still "showing".

dk, YOU the man or the woman for all I know. :wink:

Thanks again
 

Forum statistics

Threads
1,144,149
Messages
5,722,794
Members
422,459
Latest member
Chriselff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top