How do I make an excel vba project unviewable that doesnt give an enter password prompt?

[JamesU]

Hi,

I have been reading forums for a while now, I'm trying to find out how to make my excel vba project unviewable and also not give a password prompt when someone would try to unlock the vba project.

I have read different posts, some people say sharing plus some other steps, another person said use notepad++ and edit a file within the xlsm group of files, however I tried the notepad method and it didn't seem to work for me.

So I guess the first question is this, can we still do this or it only works on early versions of excel?

My second question is that I only know excel vba language from having used spreadsheets for a number of years, how difficult would it be to get my excel vba macros running so they look just like they do when run in excel with the cell values, layout, etc? (I would have loved to have learned a language like C# or visual basic using visual studio however I haven't had the free time over the years to learn it)

There are a few commercial software available which seem to do this, however they are quite expensive and I'm sure there is a reasonably simple method for doing this, ie making the xlsm workbook vba project unviewable with no enter password prompt.

Thankyou in advance,

JamesU

 

[xlhelp15]

Through API's we can do it.