Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 273
Default Forms Toolbar in Excel 2007

I use Excel 2003 for creating modeling applications that involve a lot of
buttons (extensive use of the forms toolbar and macros).

In 07, I am yet to find an equivalent to a Forms Toolbar outside of going to
the Office menu and finding the needed tools in Excel Options and the adding
the "commands not in ribbon" to the tiny shortcut bar next to the save and
undo/redo shortcuts.

Is there a way to add the forms toolbar as a module to the ribbon?

Thanks for your help,

Gary
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default Forms Toolbar in Excel 2007

Toolbars are apparently a thing of the past. But you can still get to the
Forms controls and the Controls Toolbox controls in 2007. Go to the big
round Office menu button, click on Excel Options, and search for and check
the Show Developer Tab in Ribbon checkbox. These controls are found on an
Insert button somewhere on the Developer tab. I can't tell you exactly
where, because I've got 2007 running only on my spare laptop, which is
downstairs. But you might find other things while looking around, so the
time won't be a complete waste.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Gary" wrote in message
...
I use Excel 2003 for creating modeling applications that involve a lot of
buttons (extensive use of the forms toolbar and macros).

In 07, I am yet to find an equivalent to a Forms Toolbar outside of going
to
the Office menu and finding the needed tools in Excel Options and the
adding
the "commands not in ribbon" to the tiny shortcut bar next to the save and
undo/redo shortcuts.

Is there a way to add the forms toolbar as a module to the ribbon?

Thanks for your help,

Gary



  #3   Report Post  
Junior Member
 
Posts: 1
Default

If you go into Excel Options found under the main Microsoft Button you can go to the 'Popular' tab and under 'Top options for working with Excel' check the box next to 'Show Developer tab in the Ribbon'

Quote:
Originally Posted by Gary View Post
I use Excel 2003 for creating modeling applications that involve a lot of
buttons (extensive use of the forms toolbar and macros).

In 07, I am yet to find an equivalent to a Forms Toolbar outside of going to
the Office menu and finding the needed tools in Excel Options and the adding
the "commands not in ribbon" to the tiny shortcut bar next to the save and
undo/redo shortcuts.

Is there a way to add the forms toolbar as a module to the ribbon?

Thanks for your help,

Gary
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the Max number of records/row allowed in Excel 2007 jrm Excel Discussion (Misc queries) 7 January 3rd 07 02:46 AM
Running Excel 2000 VBA Application on Excel 2003 Excel Worksheet Functions 0 August 8th 06 06:04 PM
Using Excel 2000 VBA Application on Excel 2003 Excel Worksheet Functions 0 August 8th 06 02:36 AM
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta [email protected] Excel Discussion (Misc queries) 2 July 21st 06 01:21 AM
How 2 create an Excel Form using & linking items on Forms Toolbar Beanbabeehoohoo Excel Discussion (Misc queries) 1 May 1st 06 06:42 PM


All times are GMT +1. The time now is 10:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"