I need someone expert with vba excel codes in order to modify the meny (menu Excel)
also, I have dynamic charts with formula and want to transfer that to a mirror where the user will acces only numbers and buttons to rlate the data
I'm a teacher and want to offer to my students the results online, without tehe menu who malkes possible alter or save the data by them, also, not exposing the formula.
I have the solution to put my works online by excel, only that I cant preserve the formulas and possible saving the works outside.
So, simple task:
1. dont expose the normal excel menu, only "open" function
2. all internal active plans in hide mode, protected by individual passwords
3. active external plan in mirror mode, where user can use all roll buttons to access the data, bat cant modyfy (saving) anything and cant-se nother than the results (with preserved forms, exactly like original presents)
In Brazil we named that level as "papaya with sugar", for who knows, its very easy to make.
Can You help me solve that?
I atach a simple example above
the definitive works are more complex, but the logic is ever the same...
any doubts contact me please