Excel: Protect all sheets automatically with VBA

Let me show you how easy it is to expand your Excel skills and productivity with just a few lines of code. You might have been using excel for years and never even considered that you can write your own code for excel. This post started by following the discussion on uservoice for a specific uservoice item regarding whether or not to show a lock icon on sheet tabs. Quite a few people were complaining…

Virtual Access Conference(16-17 October)

Join us this Friday and Saturday for 8 content packed sessions, delivered by Access Professionals and MVPs, the Access Development Team, and guest speakers from the Power Apps team. https://www.jstreettech.com/AccessDay.aspxWe have an amazing lineup of a speakers who will share tips and tricks on Access development, Error handling, New features in Access, dealing with web API’s, and much much more. There is even going to a virtual happy hour at the end of each day…

Excel Protection Icon on worksheets

About two months ago, the Excel team added a new feature to Excel 365 on the (windows) desktop. They added a padlock icon in front of the worksheet name if the worksheet was protected. I and many others protested this change, and requested it be removed or made optional. I won’t go into the details of why, but you can read some of the arguments on the Excel uservoice site here:https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/40858108-remove-the-lock-symbols-from-the-tabs-of-protected After quite a few…

Access Treeview Tutorial Part 6 – New Nodes and Records

Introduction This blog post is about how to use the treeview itself in combination with right click events as the platform for creating new records. This is a great feature since we can use the treeview and the mouseclick event to specify the location of the new record/node. The video As usual I have created a youtube video which shows all steps required. Hope you will like it. I hope you have enjoyed this series on treeviews…

Access Treeview Tutorial Part 5 – Right Click menu

Introduction This blog post is about how to implement right click options for the treeview, so the user will be presented with context sensitive options when right clicking a node or empty space in the treeview. The video As usual I have created a youtube video which shows all steps required. Hope you will like it. And once again, here is the sample file for download:

Access Treeview Tutorial Part 4 – Adding Icons to Treeview Nodes

Introduction This blog post is about how to use icons for our treeview nodes, improving the visual appearance of our treeview as well as providing additional information for the user about what type of record he is looking it. The video As usual I have created a youtube video which shows all steps required. Hope you will like it.

Access Treeview Tutorial Part 3 – Refresh Treeview on Record Update

Introduction This blog post is about how to handle record updates so that the treeview is always showing accurate up-to date information. I have also included a few helper functions which will make coding with the treeview a bit easier. The video As usual I have created a youtube video which shows all steps required. Hope you will like it. More explanation This time I will try to also include at least part of the…

Access Treeview Tutorial Part 2 – Navigation and mouse clicks

Hi and welcome back for part 2 of my series on using the Treeview in MS Access. This part is about how we can take action based on mouse clicks in the treeview. For now we focus on using the treeview as a means to navigate between records, but you can also use it to navigate between different type of forms just as easily (not included in this video). As before, there is a download…

Access Treeview Tutorial Part 1 – Loading data

The Treeview is a great free part of the Microsoft Common Control Library that lets you create your own Treeview and tie your own data and events into the Treeview. It can present a lot of information in a limited space, and allows a lot more versatility in presenting your information. Combine this with the ability to use small icons for each individual record, you get maximum structure on data presentation. This is part 1…