Disabling Visual Basic Editor After Protecting Worksheet/Workbook
 

Is there anyway that i can prevent a user from launching the visual basic
editor in excel on a protected worksheet/workbook? Basically i dont want a
user to be able to see any of the vb code that is on the worksheet.

Disabling Visual Basic Editor After Protecting Worksheet/Workbook
 

Reggie, you can protect the VBA project

To protect the VBA project, from your workbook right-click the workbook's
icon and pick View Code. This icon is to the left of the "File" menu this
will open the VBA editor, in Project Explorer right click on your workbook
name, if you don't see it press CTRL + r to open the Project Explorer then
select VBA project properties, protection, check lock project for viewing
and set a password. Press Alt and Q to close this window and go back to your
workbook and save and close the file. Be aware that this password can be
broken by third party software

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Reggie" wrote in message
...
Is there anyway that i can prevent a user from launching the visual basic
editor in excel on a protected worksheet/workbook? Basically i dont want a
user to be able to see any of the vb code that is on the worksheet.

Disabling Visual Basic Editor After Protecting Worksheet/Workbook
 

Hi Reggie,

Select the project in the VBE
Tools | VBAProject Properties | Select the Ptotection Tab | Lock and
password protect

Then, save,close and re-open the workbook.


---
Regards,
Norman


"Reggie" wrote in message
...
Is there anyway that i can prevent a user from launching the visual basic
editor in excel on a protected worksheet/workbook? Basically i dont want a
user to be able to see any of the vb code that is on the worksheet.

Disabling Visual Basic Editor After Protecting Worksheet/Workb
 

Thanks! thats exactly what i was looking for

"Paul B" wrote:

Reggie, you can protect the VBA project

To protect the VBA project, from your workbook right-click the workbook's
icon and pick View Code. This icon is to the left of the "File" menu this
will open the VBA editor, in Project Explorer right click on your workbook
name, if you don't see it press CTRL + r to open the Project Explorer then
select VBA project properties, protection, check lock project for viewing
and set a password. Press Alt and Q to close this window and go back to your
workbook and save and close the file. Be aware that this password can be
broken by third party software

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Reggie" wrote in message
...
Is there anyway that i can prevent a user from launching the visual basic
editor in excel on a protected worksheet/workbook? Basically i dont want a
user to be able to see any of the vb code that is on the worksheet.

Disabling Visual Basic Editor After Protecting Worksheet/Workb
 

Your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Reggie" wrote in message
...
Thanks! thats exactly what i was looking for

"Paul B" wrote:

Reggie, you can protect the VBA project

To protect the VBA project, from your workbook right-click the
workbook's
icon and pick View Code. This icon is to the left of the "File" menu
this
will open the VBA editor, in Project Explorer right click on your
workbook
name, if you don't see it press CTRL + r to open the Project Explorer
then
select VBA project properties, protection, check lock project for
viewing
and set a password. Press Alt and Q to close this window and go back to
your
workbook and save and close the file. Be aware that this password can be
broken by third party software

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Reggie" wrote in message
...
Is there anyway that i can prevent a user from launching the visual
basic
editor in excel on a protected worksheet/workbook? Basically i dont
want a
user to be able to see any of the vb code that is on the worksheet.