I have protected the view of a macro this way, but I am
having problems when another file requests this macro to
be run. Error 1004 Range of Object.

The syntax is:
Application.Run "'FileName.xls'!Import"

Is this protection causing my problem? I know the syntax
works because it did before.

Thanks,

Travis


-----Original Message-----
You can protect your code by using the passwors
protection...

Click on "Tools,VBAProject Properties" in your Visual
Basic editor, then
click the protection tab.

"AvalonDave"
wrote in message
news:CDD5103B-6245-4876-B4A2-
...
Hi,


Is there any way to hide the VB source code to my
macro I create in an
excel
workbook so i can prevent someone from stealing my
code?


Thanks,

AvalonDave


.