Solved: Disable the move or copy sheet

[grichey]

I've used the code on the kb to disable run of he mill copy and pasting. Suggestions on how to disable just right clicking the tab at the bottom and clicking move or copy would be appreciated!

Thanks

[Bob Phillips]

[vba]

Application.CommandBars("ply").Controls("Move or Copy...").Enabled=False
[/vba]

[grichey]

would that go within the workbook_open code then =true at workbook_beforeclose ???

[Bob Phillips]

Either there or in Workbook Activate/Deactivate events.

[GTO]

Hi Bob,

I must admit I feel a bit like the young student questioning the teacher, but would not you consider the Activate/Deactivate events a much better choice (presuming one does not wish to hide/kill a command/whatever for all wb's in the instance)?

Thank you,

Mark

[Bob Phillips]

Yes Mark, I do. That is why I suggested it in the previous post.

[grichey]

gracias