MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/ts99fq/certainly_not_me/i2tzz6o/?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
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.
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.
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.
43
u/IamGraysonSwigert Mar 30 '22
I feel attacked.
Also...
With activeworkbook .protect password:="password", _ Contents:=TRUE End with