Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

protecting excel macros from being changed/ seen by user

20 views
Skip to first unread message

jon tebbens

unread,
Sep 17, 2003, 2:04:12 PM9/17/03
to
How do I protect / hide a macro, so that is functions on
the worksheet, but is not available to the user?
Thanks,
Jon

steve

unread,
Sep 17, 2003, 2:22:13 PM9/17/03
to
Jon,

Go to the VBE

From the Tools menu protect the project with a password and save.

The next time the workbook is opened it will require a password to view
the code.

But remember a serious "hacker" can get in...

--
sb
"jon tebbens" <jteb...@dow.com> wrote in message
news:0b1a01c37d46$194c7650$a001...@phx.gbl...

0 new messages