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…