Develop an Excel VBA based Setup File to programmatically create Custom Tab in Excel which hosts a set of Excel macros

We have a client who wants to load a Custom Tab in his Excel. This tab will host a number of pre-designed macros. These macros are simple format based macros. Refer to the attachment to get an understanding of the identified items.

Our development effort is towards creating a sort of a 'setup file' such that whoever uses that setup file will have the Custom Tab on his Excel on his machine. Some parameters of the format based macros may change. We will have to accordingly identify 'variables' for each of the items and give a simple interface to an admin user to make changes in those variable values. For example, standard fill colour may be blue but we will give a chance to the user to change it to red.

All these changes will happen in the setup file. As the admin user may not make all changes in one go, we should give him a chance to save his draft changes. Ultimately, once the variable changes are finalized, the admin user can freeze and can create a 'version' of the Custom Tab. Accordingly, other users will load such version in their Excel. While they load a new version of the Custom Tab, they should have the option to either retain or delete the old Tab. In other words, if the user so desires, he should be able to simultaneously carry 4 or 5 versions of Custom Tab too.

The interfaces should be simple, using worksheets. Userforms are not necessary. Simplicity leading to user friendliness is more important than the robustness of process. I have mentioned about admin user and other user, but as such we won't have any user management system. We will simply give a password to the client and whoever knows the password, should be able to make the admin level changes.

While the client has given a list of format based macro requirements, you may expect about 20% scope creep in that. Your quote should accordingly have a margin for such scope creep.

Let me know if you have any questions related to this project. Let me know your quote in with expected number of working days to deliver this. Thank You! :-)

Compétences : Excel, Visual Basic pour les apps

About the Client:
( 0 commentaires ) Mumbai, India

Nº du projet : #32729074

9 freelances font une offre moyenne de 12278 ₹ pour ce travail

(175 Commentaires)
(167 Commentaires)
(102 Commentaires)

Excel VBA Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this pla Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 2 jours
(125 Commentaires)

Hello, I am the expert on SQL server, Excel, Microsoft Access and also in Power BI. I am also very skilled freelancer who completes his job with 100% client satisfaction. I have also profound knowledge in other sector Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(18 Commentaires)

Hi, I hope you are doing well I am a professional on SQL server, VBA programming, MS access and also in power BI. I am doing this job since 2010. I can handle your project in a very prudent manner. Give me a chance s Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(3 Commentaires)

Hello, My name is ayush Kumar I belong to deoghar Jharkhand. I am 21 year young man. As a person, I would describe myself as an motivated and innovative person, always looking out for opportunities to learn something n Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)

Hello sir, I thank you wholeheartedly for having seen my proposal. I want to tell you that I am a trained person who is perfect for your project. This works for me very well. i would love it if you give me this job... Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)

Best in Excel work or work dedicately in a proper way we'll maintained file in Excel sheet and do work as soon as possible

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)