On Apr 15, 1:55*am, "Bob Phillips" <bob.phill...@somewhere.com> wrote:
> Discussion Group Not Found
>
> --
>
> HTH
>
> Bob
>
> "Subodh" <getsub...@gmail.com> wrote in message
>
> news:0ee8c54d-7932-47af-b9f0-(E-Mail Removed)...
> On Apr 14, 6:05 pm, "Bob Phillips" <bob.phill...@somewhere.com> wrote:
>
>
>
>
>
> > Why are you sharing an addin, isn't that a tortology?
>
> > --
>
> > HTH
>
> > Bob
>
> > "Subodh" <getsub...@gmail.com> wrote in message
>
> >news:2f40bb63-e558-4c21-a6b3-(E-Mail Removed)....
>
> > >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.- Hide quoted text -
>
> > - Show quoted text -
>
> @ 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/comm...x?dg=micro...- Hide quoted text -
>
> - Show quoted text -
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
Similar Threads
