Disabled Functions

[vilas desai]

Dear Expert

My worksheet "Est_Wt" in the attached file has disabled functions - Cut / copy / paste / insert / delete. In fact all functions in the Insert Tab are disabled. Checked the Excel Options and could not figure out why.

Also in the Workbook object I see some passwords which I never set. Why do they appear and ho do i reset them and also remove password itself?
The worksheet code is currently indicting an error


End Select
Me.Protect Password:="Secret"
Application.EnableEvents = True




Thanks a lot.
Vilas Desai

The password to unprotect worksheet is "Secret"

[HansV]

The code should be in the Worksheet_Change event, not in the Worksheet_SelectionChange event.

When the sheet was first protected, the option to select unlocked cells was cleared:

S3479.png

This effectively disabled everything on the sheet. You should tick the check box 'Select unlocked cells'.