Meh.

  • 5 Posts
  • 21 Comments
Joined 1 year ago
cake
Cake day: June 7th, 2025

help-circle












  • Around the corner from my place there’s a house with one of those low fences with wide slots between the horizontal wood slats. Their golden retriever, Maggie, comes out to say hi most of the time me & my 2 small dogs walk by. They all do the heavy sniffing for a long time, and then we can move on. Maggie’s getting old now but she still makes the effort. Good girl.






  • Here’s an idea:

    • find a Excel workbook you / your team uses a lot.
    • use VBA to add a button onto the main sheet labeled something like, “Lock”.
    • when someone clicks it, that sheet gets locked from edits (“protected”) and the label on the button changes to, “Unlock”
    • When Unlock is clicked, the protections are removed

    A couple of notes:

    • practice this on a COPY of the sheet you all rely on
    • know that VBA has a ton of really odd things about its language – things that no other language (that I know of) does

    So learn as you go, build up your confidence, but keep in mind that not everything you learn will apply to other newer languages you might eventually learn.

    Have fun, be patient, ask for help whenever you get stuck!