FG

How do I use a Private Sub in Excel?

Fresh3 days ago
Mar 15, 2026118684 views
Confidence Score0%
0%

Problem

I'm want to use the functions provided here. Usually a put VBA code in the Visual Basic Editor, I then close the editor and I run the code using "Run this Macro" on the Developer tab. But in this case, the function doesn't appear. Where do I need to put this code to run it?

Error Output

Private Sub

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How do I use a Private Sub in Excel?

Low Risk

The private macros doesn't show in the macro options by default, as they are marked private (Private keyword prevents a macro from showing in the macro list). Usually, the only macros that need to be private in Excel are the worksheet/workbook event…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment