Sorry to post again.
But I have just discovered that even though the insert/delete command
is disabled, row/column can be inserted/deleted with the shortcut key
combinations i.e. ctrl++/ctrl+- (control plus "+" and control plus
"-"keys combinations)
How to disable it?
Regards,
Shetty.


"Loomah" wrote in message ...
Shetty
Use this code to disable/enable the row & column hide & unhide commands

Sub Disable()
Enable_Disable_Commands 883, False 'row hide
Enable_Disable_Commands 884, False 'row unhide
Enable_Disable_Commands 886, False 'col hide
Enable_Disable_Commands 887, False 'col unhide
End Sub

Sub Enable()
Enable_Disable_Commands 883, True 'row hide
Enable_Disable_Commands 884, True 'row unhide
Enable_Disable_Commands 886, True 'col hide
Enable_Disable_Commands 887, True 'col unhide
End Sub

Sub Enable_Disable_Commands(id As Integer, Enab As Boolean)
Dim myControls As CommandBarControls
Dim ctl As CommandBarControl
Set myControls = CommandBars.FindControls _
(Type:=msoControlButton, id:=id)
For Each ctl In myControls
ctl.Enabled = Enab
Next ctl
End Sub

You may want to extend this to cover insert and delete. In which case the
relevant IDs for Column are 297 & 294 respctively and for Row they are 296 &
293

;-)

Shetty wrote in message
om...
Thnks for your suggession.
But, I need to do other operations by sheetchange event which
is not working with the protect and "UserInterfaceOnly"=true.
I intend to hide some rows with workbook open event and disable
users to insert/unhide any rows/columns. If user inserts/delets
any row/column, my entire programm gets disturbed and gives
unexpected and wrong results.

Thanks again.
Regards,
Shetty


"Loomah" wrote in message
...
Hi
Could you not protect the worksheet and set the "UserInterfaceOnly" to
true?
If not you may find this link useful
http://www.tek-tips.com/faqs.cfm?spid=707&sfid=4841

;-)


Shetty wrote in message
m...
I need to disable hide and unhide commands from the context
menu as well as from main menu for the users of one work book.
With this they should not be able to unhide rows or columns
which I have made hidden by a macro.
How to acheive it?
But at the same time, I want to use these commands programatically
from a macro befor save. Also this commands should be available
to user when they activate any other workbook.
Is it possible?
Regards,
Shetty