Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disable Options in 2003
I am wanting to disable to 2003 options to where a user can not turn on the
row & column headers. Can someone please help with this. Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disable Options in 2003
hi
run this code from a standard module. this will disable the options control. to enable the options control change........ ctl.Enabled = False from False to True and run code again. Sub disableoptions() Dim myCtl As CommandBarControls Dim ctl As CommandBarControl Set myCtl = CommandBars.FindControls _ (Type:=msoControlButton, ID:=522) For Each ctl In myCtl ctl.Enabled = True Next ctl End Sub see this site for a list of MS controls. http://support.microsoft.com/kb/213552 regards FSt1 "Jeremy" wrote: I am wanting to disable to 2003 options to where a user can not turn on the row & column headers. Can someone please help with this. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - Options | Excel Discussion (Misc queries) | |||
Excel 2003 format menu disable | Setting up and Configuration of Excel | |||
Recalc Options in 2003? | Excel Discussion (Misc queries) | |||
How to disable Security Warning for Excel 2003 with NO macros | Setting up and Configuration of Excel | |||
Disable format painter in excel 2003 | New Users to Excel |