Hi Luke - your original suggestion was perfect. I didnt realise for it to
kick in i had to save and close the workbook and the reopen. When i did this,
it worked. The idea was to prevent them from seeing it, and your suggestion
did just that.

Thanks very much Luke
Regards
Matt


Luke M wrote:
To clarify:
Did you want to prevent people from seeing the code, or prevent them from
calling the macros?

The explaination I first gave was to hide/protect the code. If you don't
want users to be able to call the macros directly, place the word "Private"
in front of you subs, like so:

Private Sub MySub ()
'do something
End Sub

However, it might (depdning on your setup) be possible for a user to start
recording a macro in another workbook, and then activate the macros
(somehow?) in your book. That would tell them the name of the macro called,
but again, if you did what I said earlier, they can't edit/see the actual
coding.

Hi Luke
So, i did that. I right clikced on Module 1 where the nacro is, and set up a
[quoted text clipped - 21 lines]
Many Thanks
Matt

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200909/1