Random codes

Random 24 Codes by our developers.

Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code

2019Apr25

Carousel 34

A nice carousel in jquery, fontAwesome and bootstrap 4, using owl carousel ...

2020Aug7

Outlook data files

Custom default location for Outlook data files. Tell Outlook to always store ...

2025Jun18

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

2023Jul24

ReverseArray

Reverses order of array. In other words, the upperbound value of an input ...

2023Nov27

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

SimpleSlideView

Good slide view, animated moving menu, or wizard steps From

2019Jul4

ANStrVLookup

behaves as vlookup to return item from 2-dim ANStr Can choose which column, ...

2025Jun14

BrowseFolder

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

2018Jun14

Custom Excel UI ribbon

Excel custom ribbon in details. A good article I use as reference to add custom ...

2025May11

Excel-VBA Limits

These are some limits I found during my work in Excel-VBA For more of Excel ...

2020Feb5

LogFile_Add

Adds an entry to log file, if file is not exist, it will be created. Filename ...

2018Jul17

AN_SafeFileName

Clean filename from special characters to make it safe for server upload Then ...

2019Dec10

Thin HTML5 Coming soon Template

Simple, elegant, thin template for Under Contruction site. Found it in my ...

2023Aug19

ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

2019Apr14

Frm56Msg

A message box with checkbox, 1 command button says ok only. Caller can set ...

2022Mar3

FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

2018Jul7

ASCII_Read + ASCII_Save

Reads or Saves text into file, giving its full path. Same as

2019Oct22

Shortcuts (rundll32.exe)

Shortcuts to do certain commands in Windows (tested in Windows 7) Shutdown, ...

2019Jan1

DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

2025Mar12

ClearAllCookies

Clears all cookies created by Linkedin login, and clear sessions

2018Apr23

FS_CreateUserFolder

Creates a folder for a user, usually after sign up or login for first time. ...

2018Jul9

LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

2018Jun24

List of Databases

Script to list databases available in a server using ADODB connection From

2019Oct6