[Q] Question on using Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All ..

I have two question on using Excel

Firstly, I am using office 2003 and using excel template for managing user
account.

there are a colume using input user's e-mail address on that template excel
file.

As you know, e-mail address in excel is changed to hypertext automatically.

How can I prevent changing hypertext in Excel ??


Secondly, that template is using by End-user, and they would submit that one
to request.

So, I would like to restric just can input lowercase in some column.

How can I do this ?

I need your help, all..

thanks in advance
 
Don't know of any in-built features satisfying your needs, but do these
workarounds help at all?

1. If you format your cells as dates, when the email addresses are
entered they aren't converted to hyperlinks

2. Another column could be used to convert your email address to lower
case. e.g. =lower(C1) converts the contents of cell C1 to lower case.

If this is unsatisfactory you could write a macro which does the
conversion to lower case and removes the hyperlinks.
 
#1. Tools|autocorrect options|autoformat as you type
Uncheck replace as you type box.

#2. If you don't want to use John's formula (=lower()), you could use an event
macro that changes case when the user hits enter.

See Chip Pearson's site for the code you'd need:
http://cpearson.com/excel/case.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

If you want to read more about these kinds of events:

Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/event.htm
 
Back
Top