Dear all,
I have a .bas file contains macros. I need it running every time I open a certain .xls file with no module nor any code in it. (.xls file name always start "TopProgram.." ,example: TopProgram0709.xls). Is it possible? because all procedure at the .bas file are fit in that .xls certain file.
Any help would be appreciated,
Regards,
Mut
It is possible to import and run a *.bas file, use the VBE, click File, Import and select the *.bas file. Then open the module it was put in and run the macro.
Best regards,
Ray
ya.. Surely.. it's what I've done. But it's not flexible to new user. At the same time, I want to very hidden my macro..
Then anything I could do? to run it automatically...
Or.. I have to write some code to the .bas file??
rrr.. run it through program language .. like python.. or something.. ???
I'm newbie for those languages, though
thanks and regards
Mut
Is seems what you want is to make the macro secure. In the VBE click Tools, VBA Project Properties and select the Protection tab where you can enter your password. Please note that you can make this VERY secure, though I will not say how because it is a trade secret.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks