Profile
Achievement
cueballrawn's Recent Snippets
- 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
4041
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
4314
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
4303
posted 9 years ago by cueballrawn
Import CSV files into a named table in Access database. Use to bulk load tables.
0
4280
posted 9 years ago by cueballrawn
Lists all filenames in a directory if you need them for formulae or add into VBA.
1
4220
posted 9 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
8783
posted 10 years ago by cueballrawn
This inserts a new column in the active worksheet and lists all the worksheet names, using a row for each name. Useful if you have lots of worksheets names that you want to reference accurately.
0
4253
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
4171
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
3814
posted 10 years ago by cueballrawn