Users can still just drag and drop, though.

Bob wrote:

Found this and it works well enough
Application.CommandBars("Ply").Controls("move or copy...").Enabled = False
Application.CommandBars("Ply").Controls("move or copy...").Visible = False
Application.CommandBars("Edit").Controls("Move or Copy Sheet...").Enabled =
False
Application.CommandBars("Edit").Controls("Move or Copy Sheet...").Visible =
False

"Dave Peterson" wrote:

I don't think you protected the workbook correctly.

I'd try it once more.



sparx wrote:

Have tried and I can still insert, copy and move worksheets!.

--
sparx
------------------------------------------------------------------------
sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787
View this thread: http://www.excelforum.com/showthread...hreadid=542084

--

Dave Peterson


--

Dave Peterson