Posted to microsoft.public.excel.misc
|
|
in excel 2003 we could add a new toolbar .how to do it excel 2007
For the OP
See also this example for a menu in the QAT for macro's you want to
use in all your workbooks
http://www.rondebruin.nl/qat.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Jon Peltier" wrote in message ...
Microsoft has decided that some of its users are not savvy enough to handle
custom toolbars, therefore nobody gets them anymore. However, there is this
shadow of a toolbar called the QAT (Quick Access Toolbar) which you can add
controls to. Right click on a control and choose Add To Quick Access
Toolbar.
If you're not scared to learn some XML coding, you can create a new custom
tab for your ribbon. See Ron de Bruin's site:
http://www.rondebruin.nl/ribbon.htm
For the decimal places, click on the big ugly round Office button in the top
left, click on Excel Options, click on Advanced, under Editing Options,
click in the Automatically Insert a Decimal Point box, and enter the number
of digits you want.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"vinay kumra" <vinay wrote in message
...
In excel 2003 we could go to customise and a new tool bar . How do we do
it
in excel 2007.
in excel 2003 we could go to options and fix the no of decimals . How do
we
do it in excel 2007?
please give step by step instruction
|