Hi Dritan
Are you referring to Google Sheets? I have very little experience using Google Sheets.
It doesn't support VBA but uses GScript instead. This it self is already a big disadvantage for me.
Furthermore the number of cells is limited to 2 million per workbook (irrespective of the number of worksheets) which is just not enough for my usage.
Its charting is, at best, very basic for me. I still prefer Excel at this point of time.
Sorry I can't help on this matter.
Sunny
Hi Sunny,
I understand, but what about other alternative from Excel, like from excel 365, or from One-drive Excel?
Is there any of above options to support such a file?
Thx,
Dritani
Unfortunately I am not familiar with them. Maybe others could assist you on these.
Hi Dritan,
Excel online doesn't support VBA so you'd have to look for another way. Perhaps if you look at this post it will give you some ideas of how to embed a workbook and restrict user access.
https://www.myonlinetraininghub.com/interactive-excel-web-app-dashboard
Regards
Phil
Thank you Philip,
I'll look on your suggestion, and maybe I'll find my solution.
Best Regards,
Dritan
Anders Sehlstedt said
Hello Dritan,Personnally I would do as Frans suggests, giving each person a copy of the file containing only their sheet. I would then use Power Query to gather the data from the different files and so forth.
But to answer your question. There are some methods you can use, check out the blog articles for two different approaches.
https://www.myonlinetraininghub.com/interactive-excel-web-app-dashboard
https://www.myonlinetraininghub.com/hide-delete-and-sort-sheets-with-vba-userform
Br,
Anders
Thank you Anders,
The link are interesting, I'll look to find any solution.
Best Regards,
Dritan