In this video I will demonstrate how we can take the code from our previous 2 videos and place it into our personal macro workbook, such that it fires for all workbooks, and such that we don’t need to include the code into our regular workbooks. https://youtu.be/nn9oUsXU5PQ
Today we will focus on three simple additions to our code from last time Only run code for a specific user (myself) Prompt the user Add a simple Password to the protection So we start out in VBE, where we add the check by using a call to the Environ function, passing in the variable “UserName”. The Environ function will then return the username of the user currently logged into Windows. If that user is…
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…
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…
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…
I am currently in the process of rebuilding my site, after one of the plugins I used was compromised, through abandonment of the developer. I will repost my original articles and posts where relevant, though it may take a while. If there is anything you urgently need, feel free to contact me.
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…
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:
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.
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…