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.
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.
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.
in VBA: Menu> tools > vba_project_properties > Protection....
You can protect it with password u can it on the Menu bar..
Originally Posted by geoffc
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks