Arun,
A thought occurred to me that I haven't explained where that code would go
properly. Your menu will have various controls that have an OnAction
property that will call a macro. The code I gave you was an example of one
of those macros. IT is highly unlikely that you want to hide/show the
activesheet, that was just to make it relevant, but it also shows how to
change the control state.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"aiyer " wrote in message
...
Thanks Bob.
But it'z not clear how to spli them into 2 lines.
I tried the following and it is still giving me errors.
With Application.CommandBars.ActionControl
If .State = msoButtonUp Then
ActiveWorkbook.Worksheets(.Caption).Visible = xlSheet
Hidden.State = msoButtonDown
Else
ActiveWorkbook.Worksheets(.Caption).Visible = xlSheet
Visible.State = msoButtonUp
End If
End With
Would appreciate ur help.
Arun.
Vtec Corp.
---
Message posted from http://www.ExcelForum.com/