"Remove Duplicates" macro gives error on protected worksheet
Closed
Pluggie
Posts
11
Registration date
Monday March 11, 2013
Status
Member
Last seen
August 14, 2013
-
Mar 26, 2013 at 08:15 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Mar 26, 2013 at 06:38 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Mar 26, 2013 at 06:38 PM
Related:
- "Remove Duplicates" macro gives error on protected worksheet
- Network error occurred - Guide
- Cmos checksum error - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How to remove write protection - Guide
- Diskpart has encountered an error: the media is write protected. - Pen Drive, USB & SD Card Forum
1 response
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Mar 26, 2013 at 06:38 PM
Mar 26, 2013 at 06:38 PM
Hi Pluggie,
You are receiving this error message because your sheet is password protected. I have added the part of code that will unlock the sheet and then lock it again after executing the macro. Please check the below mentioned link to download the sample sheet:
http://speedy.sh/5FPW8/MacroProtect.xlsm
The password for the sheet is: ZOHAIB
Please revert for clarification.
You are receiving this error message because your sheet is password protected. I have added the part of code that will unlock the sheet and then lock it again after executing the macro. Please check the below mentioned link to download the sample sheet:
http://speedy.sh/5FPW8/MacroProtect.xlsm
The password for the sheet is: ZOHAIB
Please revert for clarification.