Forum

Notifications
Clear all

Hidden sheet

21 Posts
6 Users
0 Reactions
340 Views
(@sunnykow)
Posts: 1417
Noble Member
 

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

 
Posted : 15/09/2018 11:00 am
(@dritan0478)
Posts: 34
Trusted Member
Topic starter
 

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

 
Posted : 15/09/2018 11:44 am
(@sunnykow)
Posts: 1417
Noble Member
 

Unfortunately I am not familiar with them. Maybe others could assist you on these.

 
Posted : 15/09/2018 5:58 pm
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

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

 
Posted : 16/09/2018 12:20 am
(@dritan0478)
Posts: 34
Trusted Member
Topic starter
 

Thank you Philip,

I'll look on your suggestion, and maybe I'll find my solution.

Best Regards,

Dritan

 
Posted : 17/09/2018 9:50 am
(@dritan0478)
Posts: 34
Trusted Member
Topic starter
 

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

 
Posted : 17/09/2018 9:55 am
Page 2 / 2
Share: