Profile
Achievement
cueballrawn's Recent SnippetsTagged excel
- All /
« Prev 1 Next »
If you've forgotten a password to an Excel workbook that was created in version 2010 or older. See URL for more details.
0
4174
posted 9 years ago by cueballrawn
Selecting different values from a data validation drop down list will populate the same cell, i.e. it will create a concatenating list separated by commas.
Amend the "If Target.Column" values to set the columns this applies to.
0
4483
posted 9 years ago by cueballrawn
Create a custom right-click menu that will list and launch all macros in the DemonstationMacros module. Copy and past the code into the relevant object or module.
0
4463
posted 10 years ago by cueballrawn
Lists all filenames in a directory if you need them for formulae or add into VBA.
1
4408
posted 10 years ago by cueballrawn
Create a bespoke Excel function that allows you to hash (anonnymise / pseudonymise) strings such as unique identifiers. Once you've inserted the VBA, use the function "=BASE64SHA1(cellreference)" to generate the hash.
0
8972
posted 10 years ago by cueballrawn
This code allows you to open an Excel workbook from an Access database and run macros within the target workbook. This could be used to format / clean data prior to import for example.
0
4285
posted 10 years ago by cueballrawn
Hide specific worksheets in a workbook that contain a prefix. This example uses "Admin_", although this can be changed easily.
0
3958
posted 10 years ago by cueballrawn