Hello,

when using the porutguese language settings (on a US 101 international
keyboard) I cannot use CTRL+C in Excel to add a ç (C-cedile). I made a macro
for it and a menu item :

Sub cced()
ActiveCell.FormulaR1C1 = "ç"
End Sub

But when I type a word you cannot activate the macro in it, you first have
to type (or activate the macro) in an empty cell : ç and then edit the
word to the final. How can I type continouisly without this procedure?

Thanx,

Marco J.L.

Try holding the alt key, and type 0231 on the keypad. ç


"Marco J.L." wrote in message
...
Hello,

when using the porutguese language settings (on a US 101 international
keyboard) I cannot use CTRL+C in Excel to add a ç (C-cedile). I made a
macro
for it and a menu item :

Sub cced()
ActiveCell.FormulaR1C1 = "ç"
End Sub

But when I type a word you cannot activate the macro in it, you first have
to type (or activate the macro) in an empty cell : ç and then edit the
word to the final. How can I type continouisly without this procedure?

Thanx,

Marco J.L.

Maybe you could use autocorrect.

Tools|autocorrect options
give some weird combination of characters (c$ say) a replacement of alt-0231.

you'll have to type those characters then a space for the replacement to be
made. Backspace and continue typing.

(not quite continuous, though)

How about just typing the weird characters whenever you want. Then when you're
ready, just Edit|replace the weird characters with ç (alt-0231).



"Marco J.L." wrote:

Hello,

when using the porutguese language settings (on a US 101 international
keyboard) I cannot use CTRL+C in Excel to add a ç (C-cedile). I made a macro
for it and a menu item :

Sub cced()
ActiveCell.FormulaR1C1 = "ç"
End Sub

But when I type a word you cannot activate the macro in it, you first have
to type (or activate the macro) in an empty cell : ç and then edit the
word to the final. How can I type continouisly without this procedure?

Thanx,

Marco J.L.

--

Dave Peterson

And if you can use nicer characters that excel will convert as soon as you type
them--no spacebar, then backspace required: *c* worked ok for me in the
autocorrect options.

"Marco J.L." wrote:

Hello,

when using the porutguese language settings (on a US 101 international
keyboard) I cannot use CTRL+C in Excel to add a ç (C-cedile). I made a macro
for it and a menu item :

Sub cced()
ActiveCell.FormulaR1C1 = "ç"
End Sub

But when I type a word you cannot activate the macro in it, you first have
to type (or activate the macro) in an empty cell : ç and then edit the
word to the final. How can I type continouisly without this procedure?

Thanx,

Marco J.L.

--

Dave Peterson