Adding items to dialog boxes

Hi

Is there any way of adding items to the dialog box that appears when you right click on an Excel worksheet? The one with "Insert", "Delete", "Rename", "Move and copy" etc?

If so, could someone kindly paste the link to the thread?

Thanks

Matt

I meant to say right click on the tab of a worksheet within Excel...

Good morning MattRSJ

It is do-able, but it's not really for the faint hearted.
Microsoft have helpfully printed a bit of a guide here.

If that all seems like too much hard work and brain-ache, then there is an add-in available that purports to help out. I personally have never used it, but Debra Dalgleish has reviewed it in her Contextures blog here.

HTH

DominicB

Thanks DominicB

I read both of those earlier but wondered if there was a VBA way to do it. I'll have a look at those when I get a minute.

Thanks again.

Hi MattRSJ

The Microsoft link shows how to do it using VBA (the first part) or using the extensibility model (the second part). To be quite honest, neither of them are particularly beginner-friendly.

And if you've ever tried to wade through a Microsoft tutorial before, then you'll know that they're not the easiest things to follow.

Both of the above reasons are why I suggested you might want to try a route where someone else has already done all the hard work.

HTH

DominicB

Instead change the delete from cell menu code to..... Application.CommandBars("Ply").Reset. This will enable a more comprehensive reset.....Hope that helps! Skyping