Protect Workbook Worksheets, Few Worksheets to be moved/copied, editable but NOT to be renamed,

SamDsouza

Board Regular
Joined
Apr 16, 2016
Messages
205
Hello

I would like to have the following options
1. Few worksheets to be copied manually ie by Right clicking/Selecting on Sheet Tab and Moving/copying without renaming the worksheet

2. Not able to change the name of worksheets when Right Clicked/ Selected on Sheet Tab (All worksheets)

3. Able to Edit Few worksheets whichever i want. Also to be Moved/Copied without renaming the worksheet

Which subroutine i have to code in ThisWorkbook or Particular named worksheet module so that i achieve my above 3 targets

Code: in ThisWorkbook
Code:
Private Sub Workbook_Open()
   ThisWorkbook.Protect Password:="MyPassword", Structure:=True, Windows:=True
   Worksheets("Project-Ini").Activate
   Worksheets("Project-Ini").Protect Password:="MyPassword"
End Sub
The above was executed and when Right clicked on SheetTab "Project-Ini"
the following items got disabled ie
Insert, Delete, Rename, Move or Copy, Tab Color, Hide unhide
Also tried from outside ie without VBA coding I protected worksheet "Project-Ini" again with password what happend was the cells were locked and not able to modify

How can i achieve above three goals when structre and windows is password protected and also i protect worksheet thru VBA coding
have explored few threads in this forum but not satisfying

SamDsouza
 
Last edited:

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Forum statistics

Threads
1,214,792
Messages
6,121,612
Members
449,038
Latest member
apwr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top