Find Jobs
Hire Freelancers

Ms Excel restrict access

$30-250 USD

Completed
Posted over 8 years ago

$30-250 USD

Paid on delivery
We have a Ms Excel 2007 workbook and want to restrict access to some users. The workbook is attached so you can properly determine the work to be done. - it is a shared workbook. It is stored in a shared folder on a PC in the network. About 5 users have it open at the same time. 3 make changes to it (called Group A users) and 2 only need to view the data (called Group B users). - This works fine but we need Group B users to not see column J in sheet 1 and 2 - Additionally, Group B users should not be able to change or add any information - There can be one password for Group A and with this the Workbook should open with all columns visible and the ability to make changes - There can be one password for Group B and with this the Workbook is view only and column J is not visible. - You will need to provide instructions to make other columns not visible to Group B if we require this in the future Please provide a cost and time.
Project ID: 8964739

About the project

21 proposals
Remote project
Active 8 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
Hi, I can create a login page (tab) in the workbook and only show this tab every time a user open this file. Only after login detail is entered, it will open the main tab (or any other tabs) and hide the login page. The restriction to edit and hide col J can be arranged for anyone who login with group B's password. Let me know your comments, Regards, Daniel
$100 USD in 2 days
5.0 (180 reviews)
6.5
6.5
21 freelancers are bidding on average $110 USD for this job
User Avatar
Hi, I can do this job in a professional manner. I can assure you to provide 100% accurate work. Please send me the Ms Excel 2007 workbook. Please feel free to contact with me about budget & dead line. If you allow me. I am ready to start right now. Thanks bdbangla
$100 USD in 3 days
4.8 (93 reviews)
5.9
5.9
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 50 projects, almost 45+ are complex Java, VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, Java, Javascript, Restful, Ruby, Matlab, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$44 USD in 1 day
4.8 (70 reviews)
5.7
5.7
User Avatar
I have a good hold on Excel and know how to do this. Please provide me with the Excel and I can also guide you on how to do it in the future
$55 USD in 1 day
4.9 (52 reviews)
5.3
5.3
User Avatar
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will give reference of my online work portfolio once I heard from you. I am very much able to work on this. ***I am ready to start
$98 USD in 5 days
4.6 (43 reviews)
5.6
5.6
User Avatar
Hi, Please give me a chance to make your work done in time accordingly as desired. Besides this my expertise in MS Office, Presentations, Data Entries, Designing, PDF document, Google Spreadsheet, VBA, Macros and Typing. Your response is being awaited.
$82 USD in 3 days
4.9 (28 reviews)
4.5
4.5
User Avatar
I can do this job. It is not easy, but I think that I can finish this in a maximum of 5 days. I have knowledge of VBA and I'm an expert in Excel. If you are interested in my propose, then I can start right now. Regards!
$77 USD in 3 days
4.8 (17 reviews)
4.1
4.1
User Avatar
Hi, my name is Daniel, i am an excel expert and vb programmer. i can do this work for $210 in 3 days: - i am planning to create one Initial Form where the user will have to type the Group Password. - one new sheet where you can change the passwords of the user (just for the group A users, group B not going to be able to do this) - another sheet where the group A users can stablish with column the group B will not see.
$210 USD in 3 days
4.8 (13 reviews)
4.0
4.0
User Avatar
Hi, this can be done in maximum two days (with your testing). Also I have different solution if you agree. Or I can do it exactly as you requested. Optional Solution : When you open excel it will be set up for group B. (they can only see data no modifying) There will be only one password for group A. When they enter correct password they can see all columns and edit.
$138 USD in 2 days
5.0 (1 review)
1.6
1.6
User Avatar
- Certified in Advanced Excel - I previousy designed a workbook to meet similar needs and also provided users with clear instructions on how to use it. - Qualified in computer programming in Visual Basic
$155 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, i could have this done for you by COB today if you wish.
$55 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$166 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We can create an user form or a sheet with vb commands on it
$81 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir, I’m expert in this types of job and I’m very much interested in this work. I do this your job properly. Please go to my portfolio page and view my works. Your Regards Jikrullah Thank you
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i will apply my knowledge in VBA so that I can fully meet your job specification. On the other hand, the excel file is not attached so I cannot fully grasp the extent of work. I base my statement above as per your work description.
$222 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Firstly, the sample excel file you were mentioned in the description seem to be missing. About Me: Have extensive experience in excel data analytics, dashboard creation, reports creation. Specialized and recognized for the ability to automate work in excel using either built in formula or macros if needed. Also have experience in handling BPO teams where key responsibility was to divide task in hand, delegate, get the work done, consolidate the work and review. Key Skills: -> MS Excel -> Data Management (Analysis, Dashboard Preparation, Reports Preparation) -> Automation of Excel Work -> Simple Macros -> Mail Merge Solutions -> MS Office Suite -> Data Mining -> Tech Savvy
$40 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Aucune proposition n'a encore été fournie.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i have 20 years experience in computer related office work particularly Excel, Word etc. If given an opportunity, i will perform the tasks assigned to the best of my ability.
$166 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have accurate, fast keying skills and sound knowledge of computer applications. Proven ability to collect and manage information efficiently and accurately. If you provide me with an opportunity, I assure you that I won't let you down. Thanks Samin Chowdhury
$115 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i am competent in data entry with special skills in Ms word, MS excell and MS access.I am keen on details and have a good typing speed.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of TRINIDAD AND TOBAGO
Woodbrook, Trinidad and Tobago
5.0
60
Payment method verified
Member since Nov 26, 2008

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.