XLShortcut_EnableDisable

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

RunFromShared

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

ANmaVBATemplate

Template to be used for any new tools, having... D sheet, WelcomeSheet, code ...

ANmaVBATemplatev2021.14.zip

FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

XorC

Simple small function to Encrypt or Decrypt a string in cell Test_XorC is for ...

CanAccessVBA

Returns true if VBA is accessible through code, returns false if not

BrowseFolder

Asks user for a folder tested in VBA of word as well as VBA in Excel

Filesin_Coll + Filesin_Cells

Reads files in a specified folder into a Collection, work with VB6 and VBA also, ...

GetPapa, GetPapa_URL, GetPapa_Sep, GetSon, GetSon_

Gets that parent folder name giving a full path, or gets the child folder, Can ...

Calendar, a pure-VBA userform (FrmCal)

VBA pure Calendar form, no outside lib needed Edit 2020-03-18: Enhance ...

frmCal.zip

DB_SettingRead + DB_SettingSave + ...

Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...