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
4250
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
4563
posted 10 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
4535
posted 10 years ago by cueballrawn
Lists all filenames in a directory if you need them for formulae or add into VBA.
1
4479
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
9080
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
4348
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
4032
posted 10 years ago by cueballrawn