Disable "Cell" group at excel 2007 Ribbon - Home Tab

[hocs]

Hi,

How do i disable the "Cell" group (Delete / Insert / Format functions) under Home Tab at Excel 2007 Ribbon for a particular worksheet? and enable this group when this worksheet is deactivated?
(i do not want user to delete / insert or format for a particular worksheet). I have disable this from right click short cut but user can still delete / insert from Home Tab.

thanks!

 

[saltkev]

Hi

Not Sure I fully understand but an easy way would be to protect worksheet and change the allowables to suite.

1. Review
2. Protect Sheet



regards

Saltkev

 

[hocs]

Hi

Not Sure I fully understand but an easy way would be to protect worksheet and change the allowables to suite.

1. Review
2. Protect Sheet



regards

Saltkev

Hi Saltkev,
Thanks for your suggestion but excel protection is weak. Furthermore, i have macro buttons on that sheet for users to click + users to insert datas into specific rows and columns.
I don't want users to insert columns in between those specific columns. eg: users are not allowed to insert a column in between column A to column Z.
Any suggestion?

 

[saltkev]

Hi

Not sure if this will help any, as it still uses, excel sheet protection, Can be used with a command button or as a spread sheet event.

With Sheets("Sheet1")
    .Cells.Locked = False
    .Columns("A:Z").Locked = True
    .Protect Password:="mypassword"
End With

regards

Saltkev

 

[RoryA]

You would need to use XML in the CustomUI to remove the Home tab, recreate your own version and then use a getEnabled callback to enable the controls you add when you want (invalidating the Ribbon in the workbook's SheetDeactivate and Sheetactivate events). You can't disable controls just for one worksheet in a book without some work.