Posted to microsoft.public.excel.programming

Dave[_11_] Dave[_11_] is offline

external usenet poster

Posts: 41

How to hide "View Code"

Hi,
I am on Excel 2003.
I have a spreadsheet I am using the following property in a macro ,
the user can still view the "View Code" when they write click on a
tab. I would like that the "View Code" option be grayed out also along
with all the other options(which they are now)

ActiveWorkbook.Protect Password:="XXX", Structu=True

thanks in advance,

Dave

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F	daves	Excel Discussion (Misc queries)	3	April 24th 07 04:52 AM
Disable the "view code" option	Callan	Excel Programming	2	April 10th 06 11:07 AM
Missing "Custom View" entry from View menu	mycroft777	Excel Discussion (Misc queries)	1	February 3rd 06 05:33 PM
Password visible if user selects "view code"	kcdonaldson	Excel Worksheet Functions	2	December 3rd 05 03:48 PM
disabling the "view code" tab - sheet protection?	neowok[_43_]	Excel Programming	1	March 5th 04 02:48 PM

All times are GMT +1. The time now is 08:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us