Tools, VBAProject Properties and select the Protection tab. VBAProject
would be replaced by the activeproject name.

--
Regards,
Tom Ogilvy

"geoffc" <geoffc@discussions.microsoft.com> wrote in message
news:AA6E4D5C-6212-4686-8235-E453061AF6B8@microsoft.com...
> I have produced a workbook for issue to several users and do not want them
to
> be able to view/alter any of the VBA code I have created. I know how to
do
> this in Access but cannot find a way in Excel.