Protect Excel Files - Keep Your Reports Safe - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
martin
Hi mynda. Just a quick one. Do u share your reports with your clients via -Onedrive-?, and if so , I understand that U can either give them the right to view only or to edit. There is very little tutorials on hiw to share all our reports and sheets -on line- and i would think that the -essence- of the -on line- version is to get more people to use this feature. I use it all the time , but tutorials in general do not regard this topic as essential. The whole world is shifting into -on line- sharing and yet we see NOT much on -on line- interface. Am i right or fantazising ?
reply
Hi mynda. Just a quick one. Do u share your reports with your clients via -Onedrive-?, and if so , I understand that U can either give them the right to view only or to edit. There is very little tutorials on hiw to share all our reports and sheets -on line- and i would think that the -essence- of the -on line- version is to get more people to use this feature. I use it all the time , but tutorials in general do not regard this topic as essential. The whole world is shifting into -on line- sharing and yet we see NOT much on -on line- interface. Am i right or fantazising ?
reply
rahul
Hey Mynda, Thanks for another very useful video :-)
I have a question. Is there an option to disable resizing and moving of charts similar to slicers?
I have drill down buttons on my chart and I want the users to interact with the charts. So, I would want to keep the charts unlocked but I would want to lock it for movement or resizing similar to slicers. Is this possible?
reply
Hey Mynda, Thanks for another very useful video :-)
I have a question. Is there an option to disable resizing and moving of charts similar to slicers?
I have drill down buttons on my chart and I want the users to interact with the charts. So, I would want to keep the charts unlocked but I would want to lock it for movement or resizing similar to slicers. Is this possible?
reply
Rico
I normally just make my workbooks read only, or an xlst, because I get fed up of unprotecting every time I need to make a change! I usually use a plus (changing to a minus on selection) icon to replicate the pivot chart +/- buttons using a macro. I find the standard ones a bit ugly and also leave the chart open to being moved, resized etc by a clumsy user.
reply
I normally just make my workbooks read only, or an xlst, because I get fed up of unprotecting every time I need to make a change! I usually use a plus (changing to a minus on selection) icon to replicate the pivot chart +/- buttons using a macro. I find the standard ones a bit ugly and also leave the chart open to being moved, resized etc by a clumsy user.
reply
Mark
You are life saver! I learned a lot from your videos. Quick question, can you also lock the way your excel looks like when you send it as attachment? Like for example, when you hide the ribbons, formula bar, headings? And even some of the changes you made in advance option when not showing the horizontal and vertical bars and sheets? Thanks in advance! -
reply
You are life saver! I learned a lot from your videos. Quick question, can you also lock the way your excel looks like when you send it as attachment? Like for example, when you hide the ribbons, formula bar, headings? And even some of the changes you made in advance option when not showing the horizontal and vertical bars and sheets? Thanks in advance! -
reply
Filip
As always, valuable and useful content !!! One of the problems I haven't found a solution anywhere is how to secure the -official- Excel table (ctrt + T) so that the user can edit the rows (add new, change or delete) but he/she is not allowed to change the table structure (headers, formats, adding or removing columns etc.).
reply
As always, valuable and useful content !!! One of the problems I haven't found a solution anywhere is how to secure the -official- Excel table (ctrt + T) so that the user can edit the rows (add new, change or delete) but he/she is not allowed to change the table structure (headers, formats, adding or removing columns etc.).
reply
Emre
Mynda Hi,
Problem is that we are able to use VBA for unprotecting worksheets or workbook. For example, if we locked a worksheet and send it our colleagues and then if anybody knows VBA editor, he/she can make it unprotect.
So,
is there any technique to protect sheets from users even if who knows VBA ?
Thank you
reply
Mynda Hi,
Problem is that we are able to use VBA for unprotecting worksheets or workbook. For example, if we locked a worksheet and send it our colleagues and then if anybody knows VBA editor, he/she can make it unprotect.
So,
is there any technique to protect sheets from users even if who knows VBA ?
Thank you
reply
Wayne
Thanks Mynda. Glad you mentioned that Worksheet and Workbook protection available from the ribbon buttons is easy to bypass (it is). Also, just learned that you can now unhide more than one worksheet at a time directly from the Unhide dialog. Been waiting for that for years. Thanks for sharing :)) Thumbs up!!
reply
Thanks Mynda. Glad you mentioned that Worksheet and Workbook protection available from the ribbon buttons is easy to bypass (it is). Also, just learned that you can now unhide more than one worksheet at a time directly from the Unhide dialog. Been waiting for that for years. Thanks for sharing :)) Thumbs up!!
reply
Ant-nio
Thk U so much for your incredible work! I'm a great fan! Can you post the link of the video wich contains the dashboard construction please? I'm trying to do something like you (seems) to have: a combobox filtering all the dashboard objets. I can not find it. Once again, congrats for your work!
reply
Thk U so much for your incredible work! I'm a great fan! Can you post the link of the video wich contains the dashboard construction please? I'm trying to do something like you (seems) to have: a combobox filtering all the dashboard objets. I can not find it. Once again, congrats for your work!
reply
vaishali
I would like to know how to create different view in a same dashboard. One for manager view and one for employee view. When employees click the excel specific sheets should not be viewed. When managers click it all sheets should be viewed
reply
I would like to know how to create different view in a same dashboard. One for manager view and one for employee view. When employees click the excel specific sheets should not be viewed. When managers click it all sheets should be viewed
reply
Swim
Thanks for all the examples and explanations. Watching your videos has helped me to become proficient at excel dashboards. Your videos are clear, precise, informative and more importantly one can use your teaching right away. Congratulations!
reply
Thanks for all the examples and explanations. Watching your videos has helped me to become proficient at excel dashboards. Your videos are clear, precise, informative and more importantly one can use your teaching right away. Congratulations!
reply
Add a review, comment
Other channel videos
