Hide Excel Worksheet but should still be accessible

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.

Квалификация: Ввод данных, Обработка данных, Excel, Visual Basic, Visual Basic для приложений

Показать больше use forms excel database, use googlefinance excel, use mini excel, unhide very hidden sheets vba, hide excel sheet with password 2016, how to hide a sheet in excel with password, hide tabs in excel but still use them, password protect hidden sheets in excel 2016, excel button to open hidden sheet, "excel hyperlink to hidden sheet without vba", macro to link to hidden sheets, odbc driver excel iseries add use, keep links excel converting pdf, show use simulation excel, easy use webpage excel sheet, use open excel, switch excel vb6 app use open sheet, can create odbc use vba excel, use seam excel xhtml page, links excel sheet

О работодателе:
( 5 отзыв(-а, -ов) ) Lagos, Nigeria

ID проекта: #19679030



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 Больше

$15 USD за 1 день
(2 отзывов(-а))

16 фрилансеров(-а) в среднем готовы выполнить эту работу за $27


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 preparatio Больше

$50 USD за 1 день
(78 отзывов(-а))

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, Больше

$30 USD за 1 день
(31 отзывов(-а))

Hi, I’m a data analyst and have been working with excel for over 15 years. I specialise in report automation & building complex formulas. I can fix this up for you, I’m in front of the computer and can do this right Больше

$35 USD за 1 день
(6 отзывов(-а))

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 Больше

$25 USD за 1 день
(24 отзывов(-а))

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 experien Больше

$25 USD за 1 день
(19 отзывов(-а))

Hi, How are you today? I have experience in developing like your project. and I have sample code for your project. I have just read your job description carefully and I am very interesting in your job. I am a senior C, Больше

$20 USD за 7 дней(-я)
(6 отзывов(-а))

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 за 2 дней(-я)
(4 отзывов(-а))

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 за 3 дней(-я)
(1 отзыв)

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 за 7 дней(-я)
(0 отзывов(-а))

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 за 2 дней(-я)
(0 отзывов(-а))

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 t Больше

$25 USD за 1 день
(0 отзывов(-а))
$25 USD за 1 день
(0 отзывов(-а))

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 Больше

$25 USD за 1 день
(0 отзывов(-а))

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 forw Больше

$35 USD за 1 день
(0 отзывов(-а))
$25 USD за 1 день
(0 отзывов(-а))