I am not surprised, so place this line in the Workbook_Open() event procedure
to assign a hotkey:

Application.MacroOptions Macro:="UnMergeCopy", _
Description:="", HasShortcutKey:=True, ShortcutKey:="u"

Regards,
Stefi


€žAnil Gupte€� ezt Ã*rta:

That is working. Appreciate it.

What I meant about the Hot-Key selection is that it shoul dbe in th code
itself. I can just tell the users to load the sheet with the macro and
enter a key combination. You will be surprised how much work is invloved in
getting them to understand Tools-Macro-Choose the Macro-Options
blah-blah.

Anyway, thanx again.

--
Anil Gupte

www.keeninc.net
www.icinema.com
k.e.e.n., inc.
Milwaukee, WI, USA
+1-414/431-8775
Pune, MH, India
+91-20/30223100
"Stefi" wrote in message
...
This is a better tested version:
Sub UnMergeCopy()
Selection.MergeCells = False
On Error Resume Next
If Selection.Columns.Count 1 Then
Selection.FillRight
End If
If Selection.Rows.Count 1 Then
Selection.FillDown
End If
End Sub


Also, can I assign a key in the code itself?

If you mean assigning a hot key: Tools/Macro (or Alt-F8) / Others
(bottom-right button

Finally, without going through conniptions with assigning security can I
set
it so that it runs the macro in any sheet I bring up?

This macro does run in any sheet!

Regards,
Stefi