VBA to duplicate worksheets in Excel
This is part of a larger Excel VBA project I am working on. I want to duplicate worksheets based on…
Excel VBA Copy Each Sheet to a Workbook
I use digital mark sheets to mark ICT Practical Assessments; each student is marked on an individual worksheet in a…
Password-protecting your VBA Project
This post is a follow-up on how to protect Excel worksheets, providing guidance on securing a VBA Project. It details…
VBA to protect & unprotect Excel worksheets
This is part of a larger Excel VBA project that I am working on. The sheet is protected, but I…
VBA to manipulate Track Changes settings in Word
This tutorial explains how to use VBA for looping through all open Word documents and enabling Track Changes in each…
VBA for Excel: a little logic
This tutorial advances from a simple "Hello World" Excel VBA code to introducing branching If/Else logic for user interaction, with…
Clearing ALL checkboxes in an Excel workbook
Yet another “helper” script for marking CAT PAT‘s! I was modifying one of the Excel marking rubrics and to test…
“Hello World!” with Excel VBA
This post provides a simple "Hello World" tutorial for Excel VBA beginners, covering Developer toolbar activation, writing basic code, testing…
Display the full pathname of a Word document in the Title Bar
I have multiple Microsoft Word documents open simultaneously while marking CAT practical assessment papers. As I have the student’s file,…