Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excell's options
Thank you, but how do you access these options in excel
and in VBA thank you Igor |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tools options view window options | Excel Discussion (Misc queries) | |||
IF with 3 options | Excel Worksheet Functions | |||
how do I add more toolbar options to my right click options | Excel Discussion (Misc queries) | |||
Options | Excel Discussion (Misc queries) | |||
How can I enter an online list of library books into Excell's Boo. | Setting up and Configuration of Excel |