Hizi ni *trick 3 kali za Excel* kwa kutumia *VBA (Visual Basic for Applications)* `ambazo nimeamua kuwapa nyie wana ICT kama una PC yako na endapo unataka VBA yoyote sema` 1. *Auto Highlight Row When Cell is Selected* - Inaangazia mstari mzima wa seli unayogusa. *VBA Code:* ```vba Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = 0 Target.EntireRow.Interior.Color = RGB(220, 230, 241) End Sub``` 2. *Auto Save Backup Every 5 Minutes* - Huokoa kazi yako kila baada ya dakika 5 kiotomatiki. *VBA Code:* ```vba Public RunWhen As Double Public Const cRunWhat = "SaveBackup" Sub StartTimer() RunWhen = Now + TimeValue("00:05:00") Application.OnTime RunWhen, cRunWhat End Sub Sub SaveBackup() ThisWorkbook.SaveCopyAs "C:\Backup\" & ThisWorkbook.Name StartTimer End Sub ``` 3. *Password Protect Sheet with One Click* - Kulinda sheet haraka na kwa urahisi. *VBA Code:* ```vba Sub ProtectSheet() ActiveSheet.Protect Password:="1234", UserInterfaceOnly:=True MsgBox "Sheet Protected!" End Sub``` > *©️ SHAKTech143* 🗂️