I hope this isn't inappropriate. It's about passwords but not about breaking them.
I have an addin which you can see in the vba editor and if you try to view it you get prompted for a password.
I seem to recall that for added security there was something you could do so that instead of getting the password prompt you got a message that the project was unviewable.
Does anyone know how to achieve this?
I know what you're talking about, it was a bit of a hack that relied on code not being visible when the workbook is shared, but I'm pretty sure it hasn't worked for a while. It was a bit pointless anyway as it's as easy to circumvent as the password.
I am working on a long winded piece of code to do this - will come back when i have an update.
Here we go then,
I have only just cobbled this all together after finding the old way to do it via zip file editing.
This is what the file does:
1, Creates a folder called tmp in the same location as the selected file
2, Creates a zip version of the selected file
3, Extracts the zipped files to the tmp folder
4, Edits a few bits in the .bin file within the zipped version
5, Zips the tmp folder back into an excel file
6, Deletes the files it created to process
The end result should be that the code works but is not viewable in the newly created file. You will have a file in the same location as the one you selected appended with ' - Protected'
I have not put any work into neatening it up or error handling and it will only work with '.xlsm' files at this stage.
Give it a try
Hope it helps
Last edited by CheeseSandwich; 03-30-2022 at 10:35 AM. Reason: Changed attachment (again)
CheeseSandwich
This is great and very impressive.
Would it take much to get it to work with xlam and xlsb files?
Give the attached a try
If things don't change they stay the same
Fantastic. Really appreciate you sharing this.
And if you note the replaced strings you can undo it too.
I found that if you save file, the strings change so you cannot undoAnd if you note the replaced strings you can undo it too.
Thanks for sharing, always good to have a master copy of the file then just in case.
I try with xlam file but get "We found a problem with this workbook. Do you want to recover..."
should it work with xlam?
I could not get it to work with xlam files in the end unfortunately.
A pity. Still good though
Maybe someone else can get to work. It's beyond me to try
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks