| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Security Breaker
I've got a bit of VBA which breaks worksheet protection, but on inspection,
if I put a password of 'TEST' on a worksheet, it breaks it with 'AAABBBBBABB.'. Try it! Does anyone know how or why this works? Is it a bug, or is it to do with bits and bytes? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Worksheet Security Breaker
J.E. McGimpsey explains it:
http://www.mcgimpsey.com/excel/removepwords.html Damien wrote: I've got a bit of VBA which breaks worksheet protection, but on inspection, if I put a password of 'TEST' on a worksheet, it breaks it with 'AAABBBBBABB.'. Try it! Does anyone know how or why this works? Is it a bug, or is it to do with bits and bytes? Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retrieve data from all of the worksheet within the file | Excel Worksheet Functions | |||
| how to raise the Macro security level in a product I can't execute | Excel Discussion (Misc queries) | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Linear Mode
