This code not working in a Protected Sheet, can any one pls edit this code

**rajeshn_in** · 10-11-2016, 07:42 PM

Using some part of below code, I can Hide & Lock row and after 1 row hide & lock, this code not working on a protected sheet ......

Please Login or Register  to view this content.

**mikerickson** · 10-11-2016, 08:05 PM

You need to unprotect the sheet at the start of the routine and restore the protection at the end. If the sheet is password protected by the user, then your code won't know the password and you are out of luck. To test if the worksheet has been protected, look at the sheet's .ProtectContents property.

**rajeshn_in** · 10-11-2016, 08:20 PM

Below code working on Protect sheet, after adding additional code its not working

Can you please add below codes

Please Login or Register  to view this content.

**mikerickson** · 10-12-2016, 01:08 AM

You can't have two different Worksheet_Change events, they need to be combined.

This code not working in a Protected Sheet, can any one pls edit this code

LinkBack

Thread Tools

Rate This Thread

Display

This code not working in a Protected Sheet, can any one pls edit this code

Re: This code not working in a Protected Sheet, can any one pls edit this code

Re: This code not working in a Protected Sheet, can any one pls edit this code

Re: This code not working in a Protected Sheet, can any one pls edit this code

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Validation code with Protected sheet

[SOLVED] Small Edit in Code to Run For 1 Sheet Only

[SOLVED] Edit Sheet Code Via Macro

[SOLVED] New to arrays-BubbleSort code(Working)-How do I edit to sort by 2nd column then 3rd?

[SOLVED] VBA code not working with protected sheets

Edit code to copy whole sheet

Bookmarks

Bookmarks

Posting Permissions