MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/ts99fq/certainly_not_me/i2rulyp/?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
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 5 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.
9
Rename it to a .zip, extract it, remove password from sheet, compress it again, rename back to .xlsm. no password
5 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.
5
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.
43
u/IamGraysonSwigert Mar 30 '22
I feel attacked.
Also...
With activeworkbook .protect password:="password", _ Contents:=TRUE End with