Search results 48

Sorted from new to old.

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

2019Feb1

RunRemote

Runs a macro from another workbook without parameters (WB Workbook has to be ...

2019Jan9

Embed fonts in Word doc

Embed fonts used in document, to make it available on any machine

2019Jan7

Show/hide ribbon

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

2018Dec30

Permission Denied error

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

2018Sep26

XLShortcut_EnableDisable

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

2018Aug16

FixPath_Word

Fixes the path for a given folder, PC or Mac by adding separator only if ...

2018Aug9

ANmaVBATemplate

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

2018Jul26

Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

2018Jul9

WelcomeSheet

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

2018Jul9

FaceIDs

Excel menu icons and icon ids (named FaceIDs) used when yu create toolbars and ...

2018Jul9

Error_Raise

To raise a friendly error message with option to show custom error number and ...

2018Jul7

NMACode

Converts all Æ¼ found in a string into their actual chars

2018Jun27

WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

2018Jun16

GetPapa, GetPapa_URL, GetPapa_Sep, GetSon, GetSon_

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

2018May22

FrmLarge v3

Shows an image after clicking on its thumbnail, like in web applications Can ...

2018May20

1 2 3