Disable Copy Move Worksheet

[cjsmile2016]

I'm Stumped! I'm trying to find a way to disable the copy/move worksheet menu fromt the tabs, edit menu, and commandbars??? I don't want to use protect workbook or workseet due to I need the user still edit cells (using 97). Any ideas? Thank you guys!

Tim

 

[Tazguy37]

You can protect the workbook, and that will still enable users to edit cells. Hope that helps!

 

[cjsmile2016]

Thank you, thank you, thank you! Something so simple!!

Have a great day!

 

[cjsmile2016]

Re: Disable Copy Move Worksheet problems

Well, slight problem. It looks like that was going to work, but now I get in error conflict with a macro.

It seems to conflict with with macro:

Private Sub UnhideSheets()
Dim sht As Object

Application.ScreenUpdating = False

For Each sht In ThisWorkbook.Sheets

sht.Visible = xlSheetVisible

Next sht

ThisWorkbook.Sheets("Macros Disabled").Visible = xlSheetVeryHidden

Application.ScreenUpdating = True

End Sub

I get the follow error: "Run-Time error 1004: Unable to set the visible property of the Worksheet class"

When I click to debug...it points to this line "sht.Visible = xlSheetVisible"
Any clue?? Thank you!![/b]

 

[Tazguy37]

You'd have to unprotect the workbook, make all your sheets visible, then protect the workbook again.