PDA

View Full Version : VIEW CODE



Rema
11-04-2008, 11:17 PM
Hi all

Excel icon in right of File Menu in 'Worksheet Menu Bar' contains View Code option. Is it possible to disable the View Code

I want to disable the xl icon, right click menu,View Code option. is it possible.

Thank you in advance

Regards
Rema

GTO
11-04-2008, 11:46 PM
I feel like I must be missing something, but at the core, are you trying to not allo them (the users) from viewing the vba code that you have written?

As this command normally opens to the ThisWorkbook module, this was the only goal I could think of...

Mark

Rema
11-05-2008, 12:06 AM
Yes, not allowing the user to view the vba code.

i could only find SendKeys option for locking the vba project with password.

is there a way disable view code option in Excel icon right click menu
Thank you

Bob Phillips
11-05-2008, 01:54 AM
Protect YOUR projects with passwords, and don't interfere with other people's right to create their own.

khalid79m
11-05-2008, 05:12 AM
Im new to this how can i protect my projetcs

jammer6_9
11-05-2008, 05:17 AM
Im new to this how can i protect my projetcs

In VBA

Tools
VBAProject Properties
Protection
Check "Lock for Viewing"
Enter Passwords

khalid79m
11-05-2008, 05:54 AM
thanks dude