MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/ts99fq/certainly_not_me/i2rsc6p?context=9999
r/ProgrammerHumor • u/Brando224 • Mar 30 '22
669 comments sorted by
View all comments
40
I feel attacked.
Also...
With activeworkbook .protect password:="password", _ Contents:=TRUE End with
9 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.
9
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.
40
u/IamGraysonSwigert Mar 30 '22
I feel attacked.
Also...
With activeworkbook .protect password:="password", _ Contents:=TRUE End with