Excell's options
 

Hi folks,

In the Excell app there is a bar on the bottom of the app.
Usually if you press CAPS Lock it apears there. But there
are more options then just NUM, CAPS, and SCROLL Lockes.

How do you access it? and what are the options there?

thank you
Igor

Excell's options
 

Igor,

Other options include FIX for fixed decimal mode, OVR for
overtype mode, and EXT for extended select mode.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"igor" wrote in message
...
Hi folks,

In the Excell app there is a bar on the bottom of the app.
Usually if you press CAPS Lock it apears there. But there
are more options then just NUM, CAPS, and SCROLL Lockes.

How do you access it? and what are the options there?

thank you
Igor

Excell's options
 

Thank you, but how do you access these options in excel
and in VBA

thank you
Igor

Excell's options
 

FIX Tools=Options=Edit Tab, select Fixed Decimal

OVR insert key toggles this

EXT F8 toggles this.

--
Regards,
Tom Ogilvy

"Igor" wrote in message
...
Thank you, but how do you access these options in excel
and in VBA

thank you
Igor

Excell's options
 

Igor,

I think the FIX setting is the only one accessible via VBA.

Application.FixedDecimal = True
Application.FixedDecimalPlaces = 2

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Igor" wrote in message
...
Thank you, but how do you access these options in excel
and in VBA

thank you
Igor