Addins with isaddin property to false in excel 2007

  • Thread starter Thread starter Subodh
  • Start date Start date
S

Subodh

i have an addin
its shared from Review--Share workbook --and i clicked allow changes
by more than one user at a time.......
Then, i made the isaddin property of the workbook false.
I then saved it as addin
But, when i tried to load that as addin excel 2007 doesnot allows
that.
it says it is not a valid addin
that was not the case for excel 2003
any tips
or did i made any mistakes.
Tips suggestions in any form will be highly appreciated.
Thanks in advance.
 
Discussion Group Not Found

--

HTH

Bob





@ bob
Sorry, i forgot to mention.
I did that to protect Excel VBA code about as
tightly as it can be.
Jan Karel Pieterse posted a method for that and i found that useful.
Check out this discussion:http://www.microsoft.com/office/community/en-us/default.mspx?dg=micro...- Hide quoted text -

- Show quoted text -
Click to expand...
heres what the discussion group has
in order to protect the addin as tightly as possible.
1. Save the Excel workbook (.xls) file into an add-in (File >
SaveAs.....)
2. After you have the saved add-in (.xla), close the Excel workbook
(.xls)
3. Double click on the add-in to open it
4. Press Alt+F11 to access the add-in's vba project
5. Lock the vba-project with a password
6. Double-click on the "ThisWorkbook" code module
7. Press F4 to open the Properties window
8. Change the "IsAddin" status to FALSE
9. Return to Excel by Pressing Alt+Q (or close the vbe window)
10. Go to Tools > Share Workbook OR Review--Changes--Share Workbook
11. When the dialogue appears, check the box for: (Allow changes
by.....)
12. Press OK to close the Dialogue
13. When prompted to save, Press OK
14. Press Ok to accept that "macros cannot be accessed"
15. You should feel giddy at this point because you just realized what
you have
been missing right under your nose
16. Verify that the [SHARED] appears in the application title bar
17. Now save the workbook again as an Add-in (File > SaveAs...)
overwriting the
previous one (I think this should not be done.)
18. Close this Excel workbook without saving the changes (you don't
need it)
19. Test out your newly saved add-in (open it, access the vbe, try to
expand
the project window, you should get the new message "Project is
Unviewable"
20. Your done
 
Back
Top