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.
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.