Hi,
Is there a way to custom format cell?I mean when you select
column and right click on format cell you have an option to choose th
built in formats or custom format...but can we define our own forma
and include in the drop down of custom format?

--
Message posted from http://www.ExcelForum.com

Hi
Try putting the format in a blank workbook called Book1 and save this
in
your XLSTART folder

--
Regards
Frank Kabel
Frankfurt, Germany


Hi,
Is there a way to custom format cell?I mean when you select a
column and right click on format cell you have an option to choose
the
built in formats or custom format...but can we define our own format
and include in the drop down of custom format??


---
Message posted from http://www.ExcelForum.com/

Hi Frank,
Thanks a lot for your reply but I am not quiet sur
how do I define my own format when I dont have the option to do so i
the custom format cell tab?

--
Message posted from http://www.ExcelForum.com

Hi
just enter it manually in the textbox

--
Regards
Frank Kabel
Frankfurt, Germany


Hi Frank,
Thanks a lot for your reply but I am not quiet sure
how do I define my own format when I dont have the option to do so in
the custom format cell tab??


---
Message posted from http://www.ExcelForum.com/

Hi Frank,
Thanks again for the reply but when I manually ente
something in a text box the whole column changes but what I am lookn
at is...
I need to have 3 values in a column i.e
if a user enters 1 the value should cahnge to Read-Only
2 - Assessor
3- reviewer

So I have the logic coded in a macro.Can I use the macro i
the custom format drop down so the users pick it when they need it??

Any help appreciated...

--
Message posted from http://www.ExcelForum.com

Hi
now you have lost me:-)
- a format can be applied to a single cell (just select only one cell)
- if you currently use an event macro (sounds a little bit like this).
This can't be appended to the custom format dialog
- you may also take a look at
- Data - Validatiuon
- Format - Conditional format (though this won't allow locking
cells'

So in total I'm not so sure what you're really trying to achieve. A
custom format is just something like
[hh]:mm
or
DDDD DD/MM/YY

all entered in the Format - Cells dialog


--
Regards
Frank Kabel
Frankfurt, Germany


Hi Frank,
Thanks again for the reply but when I manually enter
something in a text box the whole column changes but what I am lookng
at is...
I need to have 3 values in a column i.e
if a user enters 1 the value should cahnge to Read-Only
2 - Assessor
3- reviewer

So I have the logic coded in a macro.Can I use the macro in
the custom format drop down so the users pick it when they need it??

Any help appreciated....


---
Message posted from http://www.ExcelForum.com/