VBA-Excel 353

Visual basic for applications that works only in Microsoft Excel, aka macros
Sorted from new to old.
Card image
Show/hide ribbon

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

Card image
Permission Denied error

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

Card image
TreeView

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

Card image
Listbox height changing issue

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

Card image
Scrolly

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

Card image
SheetName

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

Card image
XLShortcut_EnableDisable

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

Card image
ChartMaxY + ChartMinY

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

Card image
Hand.cur

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

Card image
Styles_DeleteNonStandard

Delete styles from an Excel workbook, any non-standard style will be deleted. ...

Card image
Page2Setting

Read content of an html online page into setting value in Excel sheet. ...

Card image
CopyRange_NoClipboard

Copies range without using clipboard. Applies formats into a cell (or range) ...

Card image
ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

Card image
SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

Card image
RunFromShared

Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...

Card image
CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...