×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

how can i hide a macro

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.

RE: how can i hide a macro

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



RE: how can i hide a macro

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 www.narendranath.itgo.com.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources