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" <[email protected]> wrote in message
news:[email protected]...
> 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