Is there a way to hide the macro so people can't look at it or alter it?
Thanks!
Printable View
Is there a way to hide the macro so people can't look at it or alter it?
Thanks!
this is the forum test area... are you sure you meant to post that question here?
Nope sorry... meant to post in Office development.
i will move it for you
yes there is...Quote:
Is there a way to hide the macro so people can't look at it or alter it?
If you are using excel then click on Tools=>VBA Project properties
Under the tab 'protection'
'check' the box which says Lock project. Enter the relevant password
You need to save the file and close to see the effect...
In MSWord the menu changes from Tools=>VBA Project properties to
Tools=>Project properties. Rest every thing is the same...
Hope this helps...
Perfect...Thanks!
How do I mark it resolved? I tried to look for it but couldn't find it. I'm sure it's right in front of my face but I can't see it.
Click on "Thread tools" just above the first post in this thread, then "Mark thread resolved".
Also, if you think anyone was particularly helpful (or particularly unhelpful!) you can Rate their post. For more info, see here
I new it had to be right in front of my face! Thanks!