Find excel workbook protect-unprotect method that works on Excel 2013 version

In Progress

I attach two Excel spreadsheets that were created in Excel 2007. First one uses workbook_open (userinterfaceonly) procedure to keep all sheets protected when various VBA modules are run; the second one uses workbook_sheetactivate (userinterfaceonly) procedure to achieve similar effect.

However, both spreadsheets give 'wrong password error' when used on Excel 2013 and when a standard VBA is run that includes: [url removed, login to view] Password:="passwordhere" command. I added an 'unprotect workbook' button to make it easier to replicate the problem.

The task is:

1) to explain why these spreadsheets (created in Excel 2007) do not unprotect/protect in Excel 2013.

2) to find a solution to this problem, to send a working spreadsheet and to give instructions on how to modify the original files (it is essential to this project that I can replicate your solution).

3) once you have a solution check whether there are any problems with protect/unprotect sheet on Excel 2013. If yes then these have to be fixed as well.

NOTE: I noticed that often with the workbook_sheetactivate procedure, the workbook can by unprotected but only if I do not change a tab. Once I select a different tab and then press 'workbook unprotect' button then an error pops-up.

All passwords (VBA, sheet, workbook) are included in the spreadsheets.

The lowest bid with the lowest delivery time will win this project. Thanks.

Skills: Excel, Microsoft, Visual Basic, Windows Desktop

See more: excel 2013 version, excel unprotect sheets, unprotect excel workbook, protect excel unprotect, excel protect unprotect, vba excel protect sheets, 2013 workbook_open, excel 2007 protect, excel unprotected workbook, to find a solution, password vba project excel, password protected excel, how to find problems, how excel works, find works, find the solution to, find the solution, find the password, find problems, find a solution, find a password, vba error, find in vba, excel uses, excel 2013 vba

Project ID: #5218590

Awarded to:

microk

Dear terefere, VBA expert here. I've unlocked the vba project to see the code. The command written(below) for excel 2007 or 2010 is not supported by excel 2013. Worksheet.Protect Password:="asfASfds342Das", UserI More

£15 GBP in 1 day
(29 Reviews)
4.4

5 freelancers are bidding on average £17 for this job

muzammil21

Dear we have a team of 12 people that can handle your task.we have done many projects..we will follow according to your instruction.pay only after the result.we will give you best result with limited time.comp More

£22 GBP in 3 days
(6 Reviews)
4.0
gamboy214

I have edited the VBA code in excel 2013.. You may download the working file here: http://jmp.sh/b/UCD2f7ZLJxJLfj8JNqiM Let me know if you're interested. Thanks. God Bless

£22 GBP in 1 day
(4 Reviews)
2.7
rangonis

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

£13 GBP in 1 day
(0 Reviews)
0.0
asadpavel1

Hear Hiring Manager, I’m very interested in your job post involving these skills. I have good experience in data entry, web research, Google documents, spreadsheet and MS excel. I believe my skills would be ideal for More

£13 GBP in 3 days
(0 Reviews)
0.0