PDA

View Full Version : Solved: Disable the move or copy sheet



grichey
09-21-2010, 12:29 PM
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
09-21-2010, 12:47 PM
Application.CommandBars("ply").Controls("Move or Copy...").Enabled=False

grichey
09-21-2010, 12:49 PM
would that go within the workbook_open code then =true at workbook_beforeclose ???

Bob Phillips
09-21-2010, 01:34 PM
Either there or in Workbook Activate/Deactivate events.

GTO
09-21-2010, 02:19 PM
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
09-21-2010, 02:38 PM
Yes Mark, I do. That is why I suggested it in the previous post.

grichey
09-21-2010, 03:09 PM
gracias