Codes Required

Card image cap
CanAccessVBA

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

2018Jun22

Similar codes

Card image cap
CTRL+K,C

Comment and de-comment lines quickly in VBE Create shortcuts inside VBE to ...

2019Jan5

Card image cap
Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

Card image cap
FontAwesome Custom icons issue

I faced an issue the past few weeks when trying to add my own icon to ...

Dec29

Card image cap
Show/hide ribbon

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

2018Dec30

Card image cap
BrowseFolder

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

2018Jun14

Card image cap
Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

Card image cap
RunFromShared

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

2018Aug9

Card image cap
CanAccessVBA

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

2018Jun22

Recently by developer

Card image cap
ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Tue 8AM

Card image cap
SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

Card image cap
ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

Card image cap
CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Apr17

Random Codes

Card image cap
blueimp Gallery

Touch-enabled, responsive and customizable image and video gallery, carousel ...

Aug16

Card image cap
CSS Radiochecks

Radio checkboxes in pure CSS

2019Jan15

Card image cap
ConfigWeb_Read

Reads a key value from certain section in Web.config Originally from ...

2018Sep5

Card image cap
WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

2018Jul9