Meh.

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

help-circle











  • 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!