how can i hide a macro

[spring456]

how can i hide a macro in microsoft excl sp any one cant see it or modify it?
and how can i protect a sheet so anyone cant change it.
thanks alot.

 

[BruceMutton]

Macros
In the Visual Basic Editor, programmers can protect macros so that they can't be viewed or changed by users. Programmers can protect macros by using the Protection tab of the Project Properties dialog box in the Visual Basic Editor (Tools menu, Project Properties command). For more information, see Visual Basic Editor Help.

Assuming you have access to Excel 2000, use the visual basic editor help to look up the following topics;
-Protect workbooks and worksheets from changes
-About protecting workbooks and worksheets from changes

 

[narenr]

Simple, select the cells to be protected,
use format->cells->protection->locked/hidden
then use tools->protection->protect sheet->password,
this will protect the cell formulas from accidental
erasure or changes by others.

For protection of macros, in the visual basic editor,
use tools->VBAproject properties->protection->tick lock project for view/password. This will protect the macros.


Narendranath R
narenr@narendranath.itgo.com

http://www.narendranath.itgo.com

Pipeline engineering is made easy with state of the art computer software, visit

http://www.narendranath.itgo.com.