how can i hide a macro
how can i hide a macro
(OP)
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.
and how can i protect a sheet so anyone cant change it.
thanks alot.





RE: how can i hide a macro
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
RE: how can i hide a macro
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 www.narendranath.itgo.com.