Prev: Duplicate data
Next: Excel calcutions using date/timestamps
From: Jeremy on 14 Apr 2010 13:53
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
From: FSt1 on 14 Apr 2010 14:36
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
 | 
Pages: 1
Prev: Duplicate data
Next: Excel calcutions using date/timestamps