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