In Progress

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

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

About the Employer:
( 38 reviews ) terefere, United Kingdom

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. [url removed, login to view] 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 [url removed, login to view] have done many projects..we will follow according to your [url removed, login to view] only after the [url removed, login to view] will give you best result with limited [url removed, login to view] 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: [url removed, login to view] Let me know if you're interested. Thanks. God Bless

£22 GBP in 1 day
(4 Reviews)
2.7
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
rangonis

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

£13 GBP in 1 day
(0 Reviews)
0.0