LinkBack URL
About LinkBacks
hi,
what happens if the worksheet is protected and was to stay protected could this add in let the user in
does this also apply to the macros that are protected
steve
hi,
what happens if the worksheet is protected and was to stay protected could this add in let the user in
does this also apply to the macros that are protected
steve
Hi stevekirk
The add-in removes worksheet / workbook protection due to a substantial weakness in the protection routine, the knowledge of which has been in the public domain since Excel 97, but Microsoft chose not to address until Excel 2007. Microsoft's line is that the protection is there not to stop people changing the spreadsheet without authorisation, but to stop accidental erasure of formulae.
Macro protection is a little trickier but can be still be removed relatively quickly (my tool of choice for this is a hex editor), and the protection whereby a password is required to open Excel is trickier still - but not impossible. Just type "Excel password cracker" into Google to see...
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
I just tried to use the remove protection command again and I can't get it to work anymore. Is there a trick that I unknowingly did the first time? Any little quirks that you have to do or the order of anything? The box that has Close/Start isn't popping up anymore.
Hi wmorrison49
No quirks or anything tricky. I've never come across this or had it reported as an issue. Usual kind of advice applies - restart Excel and try running it. If this doesn't do the trick try reinstalling from the setup file and making sure that the add-in is invoked properly.Any little quirks that you have to do or the order of anything?
HTH
DominicB
I don't see a link for the add in, i'm having the same problem, not sure if that would still work 16 years later..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks