Macro Thiefs

[nona]

Is there a way that I can hide my Macros? Or can I change the font color in my micro editor so that all that is seen is white text on white background?

Nona

 

[mwperkins]

How about right-clicking the VBA Project, selecting "VBA Properties...", going to the "Protection" tab and locking the project with a password?

 

[nona]

Thanks perkins for the speedy reply. I want others to view the excel document, but I don't want them to copy the Macros.

 

[mwperkins]

that should work.

Are you sure you mean macros (ie the vba code that you have recorded or written) - if so, password protecting the VBA project should be OK.

If you mean that you want to hide the formulas in cells, that's different.

 

[nona]

Thanks again. Yes, I am speaking of the code in the VBA editor and not the formula. I know that you know what your talking about, but incase I am not clear here is an example code:

[ActiveSheet.Paste
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True]

I can't find the VBA object. Is that the window that pops up when I press f4?

Nona

 

[nona]

wait, i press F2 and got VBA project. When I go to properties I get a pop up box that says member option and all I can do there is write a description, it doesn't have any tabs.

nona

 

[nona]

Thanks for all of your help. i did find the properties for the VBA project, however it didn't lock the VBA code. When I go to run>macro>select Macro Name>edit> It shows the code and someone could copy the code.

 

[nona]

You were right. When i closed the file and opened it back up the edit button was greyed out. Thanks for your lead in and help!

Nona