Excel Vba Project Unviewable Unlock
Liese Hittson
When launched automatically at startup the VBA project in .DOTM files are not viewable. I couldn't find this clearly documented by Microsoft but I tested/replicated it across multiple OS and versions of Office to conclude it was "by design"
For anyone having this issue that uses Office 365 with OneDrive, please note that if your docm document was previously synced to your OneDrive, but your OneDrive is currently logged out, this will cause the "Project is unviewable" error. If you log back into OneDrive and sync the docm file, you should be able to edit the VBA as normal. In my case, this fixed the issue.
The unviewable state in VBE can be achieved by a much easier method: by protecting the workbook with a sharing password. However, Unviewable+ locked files are defended by several protection layers behind the scenes. Please review the demo samples available at product page.
Your product, Petros, is not working. And the samples provided on the site are not working, and you failed to prove otherwise for more than 60 days. Not to mention the unprofessional communication you conducted.
Furthermore, it is said to be easily crackable, hence, useless.
-for-excel-vba-protection.863055/
The ultimate way to protect an excel worksheet is to first, save your project as a .xlsb file, then apply the method explained by RATEXCEL. You can change the file extension to .xlsm again if you want,
Hi all, I tried to use Lance script and for me it worked, I think! Project unviewable for Excel 2016 xlsm file. After, saved it to XLS and tried to do the DPX trick. File corrupted, nothing inside the file or the VBA Project. Do you guys had the same results? Lance, your file gives me unexpected error 40230 while opening. despite working. Also, cant we always force user to save the file as xlsm or xlsb? Would it help?
UNVIEWABLE PASSWORD-PROTECTED VBA PROJECT
Unviewable password-protected VBA projects are less secure than the equivalent locked projects, as recovery information has to be maintained within the file.
Unviewable password-protected projects can be made visible and re-locked if required. This setting is provided for developers who need to maintain their code, without having to publish updates to replace locked files. The project cannot be restored by the application if the unviewable password is lost.
UNVIEWABLE LOCKED VBA PROJECT
Permanent protection. Please ensure that you have a backup copy of your source file before locking a VBA project with this setting. Locked VBA projects cannot be made visible by the application.
MEDIUM STRENGTH
A good option if the Ultimate protection restrictions conflict with your setup. Also an ideal setting for beta VBA applications or projects with poor error-handling (ie the Debug message box may pop up when users do something wrong).
I downloaded an excel file having a few very interesting macros attached.
The problem was that the VBA project was password protected. So I used the
"Hex method" for replacing the password, but when I try to access the VBA
project, instead of dialog box for password input, I receive the message
"Project is unviewable". 2 additional comments:- the file is not shared;
- I don't know in what version of excel the file was created (I use Office
2003), but I don't think is relevant because before "Hex method" when I tried
to access the VBA project a dialog box opened (so no "Project is unviewable"
message).Thanking in advance for any help,Bogdan
You say you have downloaded a file, if project is locked it means the author
does not want to share the code that may have taken considerable time to
write. Is there a valid reason why you should not respect that.Regards,
Peter T
"Bogdan" wrote in message
news:A23316CF-6AAB-41F9...@microsoft.com...
I have excel addin created using excel 95 version. I couldnt open the macro
since its throwing "Project is unviewable" warning. Please help to view the
macro code using Hex method or any other way.You can write to my email id
a_su...@yahoo.co.in. Thanks in advance.--sudha
Consider the situation when the translation to a compiled programming language does not cover the whole VBA project code but only several VBA methods. In this case the X value, representing the amount of work hours, should be adjusted accordingly.
make sure you are adding the template using the "document template" button on the developer tab, and that you specify the template under "document template" (i.e. replace normal.dot with your custom template). if you instead add the template tot he "global templates and add-ins" section, you will receive the "project is unviewable" error when trying to expand it in the vba window.
I wrote a chess game in excel and the users would save their workbook to post their changes and it would create a history of the game and I thought I had to unshare the workbook to get into the macros but maybe my memory is blurred.
Weird! Just working on an Excel project and noticed unviewable rows. The left edge goes nicely from row 1 to row 733. Then there's a thick-ish green cell-bottom line, and the next row is 1071. Hovering over the green line yields the parallel lines. Click on that and the row number after 733 is now 1070, so 1 row closer. I could do this another 337 times, but wondering what I did to cause this - and maybe how to solve it.
b9b4d2437c