Mac Forum / Applications / Excel / August 2007

Hmmm...

Well, there is one (Window/Hide).

I set my keyboard shortcuts via macro, and would have sworn that the
Format/Row/Hide and Format/Column/Hide commands were available as well.
Seems I was incorrect.

As a workaround, one can easily set up one's Personal Macro Workbook (or
another add-in or file in the the Startup menu) to provide this
functionality.

In the Personal Macro Workbook's ThisWorkbook code module:

   Private Sub Workbook_Open()
       HideShortcuts
   End Sub

In a regular code module (Insert/Module):

   Public Sub HideShortcuts()
       With Application
           '  *+h  ===> CMD-SHIFT-h
           .OnKey Key:="*+h", Procedure:="HideRow"
           
           '  *%h ===> CMD-OPT-h
           .OnKey Key:="*%h", Procedure:="HideCol"
       End With
   End Sub

   Public Sub HideRow()
       'Format/Rows/Hide control ID = 883
       CommandBars.FindControl(Id:=883).Execute
   End Sub
   
   Public Sub HideCol()
       'Format/Column/Hide control ID = 886
       CommandBars.FindControl(Id:=886).Execute
   End Sub

See the OnKey method in VBA/Help for more potential key combinations.

On Aug 27, 4:21 pm, Mark Aalyson <anonym...@zerospam.org.invalid>
wrote:

I was tricked by seeing the Keyboard... button after double clicking
"Hide" as I described. As you say, that leads to a dead end. But, if
you rename to "Hide Row" and then use the "system preferences" route,
you should be ok.
jpdphd