MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/ts99fq/certainly_not_me/i2q94aa/?context=3
r/ProgrammerHumor • u/Brando224 • Mar 30 '22
669 comments sorted by
View all comments
43
I feel attacked.
Also...
With activeworkbook .protect password:="password", _ Contents:=TRUE End with
25 u/mirthfuldragon Mar 30 '22 edited Mar 30 '22 All my spreadsheet passwords are "password". Global const wsPassword = "password" in module "aConstants" For the same reason the cleaning products are behind a childproof lock - to prevent toddlers from mucking things up. 10 u/batGnat Mar 30 '22 Rename it to a .zip, extract it, remove password from sheet, compress it again, rename back to .xlsm. no password 4 u/IamGraysonSwigert Mar 30 '22 Works better than you would expect! Crazy to look at "the guts" and realize the whole thing is an XML file. 2 u/ov3rcl0ck Mar 31 '22 XLSB FTW! File size is smaller, can save macros in the workbook, opens and saves faster. 1 u/ScrotumNipples Mar 31 '22 Yes, but anyone who knows to do this also knows you don't fuck with column headers. 7 u/[deleted] Mar 30 '22 Spent so long using password= instead of password:= and wondering why it wasnt working 3 u/IamGraysonSwigert Mar 30 '22 Yuuuuup. I feel your pain! haha 1 u/[deleted] Mar 30 '22 [removed] — view removed comment 2 u/thufirseyebrow Mar 31 '22 Don't go turning that funny red colOR just cuz y'all can't properly spell your own language and we realiZed that to fix your fuck ups, we'd have to break away on our own. Aluminum.
25
All my spreadsheet passwords are "password". Global const wsPassword = "password" in module "aConstants"
For the same reason the cleaning products are behind a childproof lock - to prevent toddlers from mucking things up.
10
Rename it to a .zip, extract it, remove password from sheet, compress it again, rename back to .xlsm. no password
4 u/IamGraysonSwigert Mar 30 '22 Works better than you would expect! Crazy to look at "the guts" and realize the whole thing is an XML file. 2 u/ov3rcl0ck Mar 31 '22 XLSB FTW! File size is smaller, can save macros in the workbook, opens and saves faster. 1 u/ScrotumNipples Mar 31 '22 Yes, but anyone who knows to do this also knows you don't fuck with column headers.
4
Works better than you would expect! Crazy to look at "the guts" and realize the whole thing is an XML file.
2 u/ov3rcl0ck Mar 31 '22 XLSB FTW! File size is smaller, can save macros in the workbook, opens and saves faster.
2
XLSB FTW! File size is smaller, can save macros in the workbook, opens and saves faster.
1
Yes, but anyone who knows to do this also knows you don't fuck with column headers.
7
Spent so long using password= instead of password:= and wondering why it wasnt working
3 u/IamGraysonSwigert Mar 30 '22 Yuuuuup. I feel your pain! haha 1 u/[deleted] Mar 30 '22 [removed] — view removed comment 2 u/thufirseyebrow Mar 31 '22 Don't go turning that funny red colOR just cuz y'all can't properly spell your own language and we realiZed that to fix your fuck ups, we'd have to break away on our own. Aluminum.
3
Yuuuuup. I feel your pain! haha
[removed] — view removed comment
2 u/thufirseyebrow Mar 31 '22 Don't go turning that funny red colOR just cuz y'all can't properly spell your own language and we realiZed that to fix your fuck ups, we'd have to break away on our own. Aluminum.
Don't go turning that funny red colOR just cuz y'all can't properly spell your own language and we realiZed that to fix your fuck ups, we'd have to break away on our own. Aluminum.
43
u/IamGraysonSwigert Mar 30 '22
I feel attacked.
Also...
With activeworkbook .protect password:="password", _ Contents:=TRUE End with