Open different Filestypes

Populate list of filetypes in Application.GetOpenFilename method. This command ...

Run macro

Runs a macro from another workbook (Workbook has to be open).

Protect VBA

Protect VBA project from inside VBA This is the raw way, there has to be other ...

Show/hide ribbon

Show or hide Excel ribbon from inside VBA Needed that in one of my projects

Permission Denied error

Issue: Trying to copy file (Using VB command FileCopy) while that file was ...

TreeView

A plain pure VBA Treeview control to be used inside Excel (official link has ...

treeviewexcel025.zip

Listbox height changing issue

Listbox in Excel sometimes have issue adjusting height to items added inside, ...

Listbox height changing issue.zip

Scrolly

Scroll a listbox Using Right-Drag. (Something VBA in Excel lacks) You might ...

scroll_Listbox.zip

SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

XLShortcut_EnableDisable

Disables or Enables certain Excel built-in shortcut. Code has example on how ...

ChartMaxY + ChartMinY

Calculates the maximum of the chart Y Axis to draw, the shifted one, not exact ...

Hand.cur

A cursor file type of Hand. used inside VBA to show hand when user hover over ...

hand.zip