Hide Excel Worksheet but should still be accessible

$10-30 USD

Opravljeno

Objavljeno

pred skoraj 5 leti

$10-30 USD

Plačilo ob dostavi

I already gave this project to a freelancer who ran a macro to hide some worksheets if user login and user is NOT admin. Problem now is that once user login, it hides other worksheets but user can still rightclick on the tab menu and unhide the sheet. If I change the settings of the worksheet to xlVeryHidden then excel does not link the formulas in those sheets to other worksheets and the model therefore becomes useless. The model is built with many worksheets and formulas. The first two worksheets contain navigation links that can direct users to all other worksheets. So once user login, i only want them to see the first two worksheets (see attached) and not being able to right click and unhide other worksheets but formulas should be readable in those hidden worksheets after use login.

Visual Basic for Apps

ID projekta: 19679030

Več o projektu

16 ponudb

Projekt na daljavo

Aktivno pred 5 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

Dodeljeno:

@imfarrukh47

hi, I read your problem and as per my understanding, you want to hide your worksheets and except 1st two but on the other hand, you also want all of your formulas to work properly. well, I am an excel expert and open a message box so we can discuss further. I have a very simple solution (can be done in less than a minute) maybe it works for you. If it does then you can award me a project. Waiting for your response thanks

$15 USD v 1 dnevu

5,0

(2 ocen)

2,0

16 freelancerjev je oddalo ponudbo s povprečno vrednostjo $27 USD za to delo

@dgled

hi. I can help you that issue. I am an expert and guru in Financial, Math and Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (script for charts). I am sure that my combined knowledge, skills and creativity will lead to exceptional results that will exceed your expectations.

$50 USD v 1 dnevu

4,9

(78 ocen)

7,0

@khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing, Virtual Assistance and Touch Typing 60wpm Skills.

$30 USD v 1 dnevu

5,0

(31 ocen)

5,6

@gsanggara

Hi Havilah, I am interested to your project. I am an Excel expert and have a great experiences in Excel automation with formula and vba since my first career. I assured that you will be get high quality / high accuracy / high turn around service with best price. I can fix your issue with hiding the excel tab for credential. please contact me to discuss further details. Thank you Best Regards, Garbo

$25 USD v 1 dnevu

4,8

(24 ocen)

4,0

@paulodayto08

Hi Good Day! A serious freelancer here. I've done a lot of job like this before and I can help you with this project. Can you share your file so I can access? thanks!. Please consider my bid. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!

$25 USD v 1 dnevu

5,0

(19 ocen)

3,6

@razvancotofana

Hello, I have over 10 years of experience in creating dashboards and reports with different access levels and I'd like to try yo help you with your report if I can. BR, Razvan

$20 USD v 2 dneh

5,0

(4 ocen)

1,8

@anamimtiaz01

hi, I am a software engineer and i do the data entry work. i can resolve this issue at this cost within thiz time line. Time line can be manageable

$30 USD v 3 dneh

5,0

(1 ocena)

1,3

@hasitha321

I can work Excel sheets very well and enter data correctly without making errors in proper manner so you will not get confused with the data

$20 USD v 7 dneh

0,0

(0 ocen)

0,0

@khaldalfalah

I think you can make this by use a password to show the needed sheets and the admin have this password and same time al formula will work completely.

$30 USD v 2 dneh

0,0

(0 ocen)

0,0

@muhammadnakash

Hello, During the last 3 years, I have completed many Data Entry, Web research, Wordpress, SEO, MS word, MS excel, PDF to excel or word convert, JPG to word, any kind of data entry related work projects. As I always try to provide an excellent service. I trust in the delivery of quality work, not quantity. If the work needs to be done fast and efficiently then I'm the person for the job. I can assure you that your project will get the professional attention it deserves. I look forward to hearing from you. I am very professional and will provide the project on delivery time. I am available 24/7, feel free to contact with me Many thanks,

$25 USD v 1 dnevu

0,0

(0 ocen)

0,0

@emklein10

I could fix your situation using a custom startup program. This would both ensure file access and association of user login. It could start with the computer's OS and create any set of rules you require. I could do this in around 40 min, Delivery in under 24 hrs.

$25 USD v 1 dnevu

0,0

(0 ocen)

0,0

@sottoeugene

Hi there! I am very interested about your current issue and I think I have a solution to that. I have been writing alot excel vba for automation of reports at work for 8 years now. So when are we starting? Looking forward to working with you.

$35 USD v 1 dnevu