Menu
Does anyone know how to make a template viewable in Word 2007? I created a template, Experiments.dotm, added it using Add-Ins, but when I try to create a module within it, get an error message: "Project is unviewable"
885
asked May 16 '11 13:05
Go to Tools > VBAProject Properties > Protection Tab. Put in a new password and save the . xlsm file. Close and re open and your new password will work.
Then, right-click on Normal in the Project pane in Word, VBAProject in the Project pane in Excel or PowerPoint, or a numbered project, like Project1, in the Project pane in Outlook. Go to Insert > Module. Press Ctrl + V to paste the macro code into the Code window. Click Save or press Ctrl + S to save the macros.
The explanation for the "Project is unviewable" problem can be found here:
It is important to differentiate between opening an add-in file (for example, by clicking File and then clicking Open) and loading an add-in (for example, by using the Add-Ins button on the Developer tab). Open a file when you want to edit it and test it. Load the file as an add-in when you want to use it.
In summary, if you load VBA as an add-in, then any time you want to edit it, you have to open the .dotm in Word (File... Open) before you try to access it in the VBA editor.
101
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
