Sheet-Specific Macro vs. Global Macro 1. Sheet-Specific Macro vs. Global Macro The code we used (Worksheet_SelectionChange) is specific to a single sheet. This means it only works on the sheet where you pasted it. If you have multiple sheets in your workbook and want the highlighting effect to work everywhere, you need to copy this same code into each sheet individually. 2. Copying the Code into Each Sheet In the VBA editor (Alt + F11), you'll see a list of all the sheets in your workbook in the left pane. Double-click on each sheet (e.g., "Sheet1", "Sheet2", etc.) and paste the same code into each one. This ensures that dynamic highlighting is activated regardless of the sheet you use. 3. Alternative with a Global Module If you want a more advanced solution, you can create a global macro in the ThisWorkbook module that detects selection changes in all sheets. This requires a bit more programming, but it's doable. For quick and easy use, copying the code into each sheet remains the most direct method.