Find Jobs
Hire Freelancers

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

£10-20 GBP

In Progress
Posted over 10 years ago

£10-20 GBP

Paid on delivery
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: [login to view URL] 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.
Project ID: 5218590

About the project

5 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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. [login to view URL] Password:="asfASfds342Das", UserInterFaceOnly:=True I know the alternate option. Please install teamviewer and give me remote access to your machine. I'll fix this for you right now. Best Regards, Microk
£15 GBP in 1 day
4.9 (29 reviews)
4.4
4.4
5 freelancers are bidding on average £17 GBP for this job
User Avatar
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
£13 GBP in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
terefere, United Kingdom
5.0
38
Payment method verified
Member since Aug 21, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.