Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

drawing toolbar

The drawing toolbar is visible, but the functions are not usable on any
worksheet. How can the toolbar be reactivated? NOTE - I reviewed the other
question on this topic and 1)Workbook and Worksheet are NOT protected
2)Workbook is NOT shared and 3) worksheets are NOT grouped. Also, there are
no "disabled items". If I open a NEW workbook, it has an active drawing
toolbar, thr problem appears to be limited to this one workbook. Thanks in
advance.

I am using Excel 2003 Professional
Edition SP2


Post your answer or comment

comments powered by Disqus
I want a way with code to turn off the "Select Objects" button on the drawing toolbar.

The reason for this is that I am trying to select a range of cells by finding the last one in the appropriate column, then using a range select to select everything between there and the start of the sheet:


	VB:
	
Range("B65536").Select 
Selection.End(xlUp).Select 
Range(Selection, Cells(1)).Select 
ActiveWorkbook.Names.Add Name:="BOM_Print_Area", RefersToR1C1:=Selection 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Then I want to assign a Name to this range. However, if the user has the "Select Objects" mode on, the range select will not work.

Any clues?

TIA,
Scott.

Hi all,

I am routinely emailed a spreadsheet which contains among other things a textbox (one created from the Drawing toolbar). The text box reference / number can change eg textbox1 or textbox24 etc. I cannot predict what it will be. I have written a VBA macro which copies the contents of the spreadsheet to a worksheet which is then used to process the data......

However... I have not been able to get the text box text to copy and paste to a destination text box. There is only ever one textbox on the sheet I am emailed. Is there a way that I can find out the textbox reference, then select its contents and paste to another textbox??

Any ideas gratefully accepted.

From the Drawing Toolbar I cannot click the Line Style, Dash Style or Arrow Style icons and use them. (I can click the icon but the line/dash/arrow options are grayed out).

Am I missing an addin or a setting?

Wanted to see if anyone had a fix for this short of re-installing Excel. My drawing toolbar is not available. Even if I go to Tools|Customize|Toolbars, the Drawing toolbar is not listed. I've created a user toolbar to replace the lost Drawing toolbar, but the geek in me wants the 100% fix!

Any insight would be appreciated.

Owen

I'm trying to label some plots for my thesis using the arrows and text
boxes that are available on the "Drawing" toolbar.

However, whenever I try and turn this toolbar on, either by using the
'view - toolbars' menu or by selecting 'customize toolbars/settings', I
get the dreaded spinning beach-ball of death (Excel freezes). Eventually
I have force-quit.

I've tried uninstalling Mac Excel Expander which I've been using, and
even reinstalled MS office entirely using only what comes on the
install disks, but nothing seems to work.

Has anyone else seen this issue? Is this a known bug? Any solutions?

I have one possible work-around. It looks like I am able to select
individual buttons from the 'customize' menu, and I could reconstruct a
'drawing' menu by tacking the individual buttons onto an existing
toolbar. This is a pain since there are alot of drawing items I need.

I'm using Excel 2004 For Mac

Any thoughts you might have would be appreciated.

Thanks
Kevin

--
KevinW
------------------------------------------------------------------------
KevinW's Profile: http://www.excelforum.com/member.php...o&userid=30019
View this thread: http://www.excelforum.com/showthread...hreadid=534413

I need to find the Draw toolbar so I can add lines to a file. No Draw
toolbar up on top???

Excel 2003 always opens with the drawing toolbar displayed. I don't want the
drawing toolbar displayed. I can manually remove it but next time I open
Excel it is back. What can I do to have Excel open without the drawing
toolbar?

Is it possible to change the default line thickness for ALL lines and
rectangles to be drawn from the drawing toolbar (until you change the
defaults again).

Thank you.

I am also having a problem with "inactive" drawing toolbar. I have tried
everything here but none of these suggestions seem to resolve the problem.
The situation is - I have a chart that I usually add some text boxes to and
draw some lines accross to show some indicators. I copied the workbok from
last quarter to begin my modifications for this quarter. But the drawing,
text boxes, and drawing toolbar didn't come over with it. Any other ideas?

"Dave Peterson" wrote:

> Sharing a workbook allows multiple users to edit it simultaneously.
>
> If you don't need this:
>
> Tools|share workbook|Editing tab
> Uncheck that option
>
>
>
> nosell wrote:
> >
> > I haven't protected or grouped sheets, but I see "[Shared]" in the title bar.
> > I don't know why or how that got there. This file is not in the "Shared
> > Documents" file.
> >
> > Other funtions are greyed out and inactive as well - such as "Protect Sheet"
> > and "Table" on the "Data" menu. If I open a new worksheet, everything seems
> > to be fine.
> >
> > Anyway, thanks to everyone who replied. I'll keep looking for the solution
> > and will post if and when I find it.
> >
> > nosell
> >
> > "Dave Peterson" wrote:
> >
> > > Have you grouped sheets?
> > >
> > > Look for [group] in the title bar.
> > >
> > > (If the worksheet wasn't protected.)
> > >
> > > nosell wrote:
> > > >
> > > > The drawing toolbar is visible, but the functions are not usable on a
> > > > particular worksheet. How can the toolbar be reactivated?
> > > >
> > > > I am using Excel 2003 Professional
> > > > Edition
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>

I simply want to add a Text Box to an Excel Chart.
Although I can open the Drawing Toolbar OK, some comands on it are
greyed-out and do not function?
How can I activate the Text Box command?

By the way, if I create a new spreadsheet, all the Drawing Toolbar commands
are active. So I conclude that the problem lies with the specific spreadsheet
that I am working on rather than the software or any general settings.

It seems so basic, but I would really appreciate help on how to fix it.
Thanks.

I want to put a shadow on a cell in a spreadsheet and cannot figure out how
to do it. I cannot find the "drawing" toolbar. What am I doing wrong?

There used to be a pencil on my drawing toolbar that would allow me to draw a
line in a cell that would split it into two separate cells. How do I get
that function back? We recently installed Office 2003 at work, was this
function removed from this new version?

To get to the Drawing toolbar is really inconvienent. Is there a way to put
an icon in the quick toolbar?
Thanks Irv

What is the name of the icon on the drawing toolbar that has arrows, one
pointing right, then one pointing left, then one pointed right ?

Hi

I've recently got a new computer and this problem is driving me nuts.
When I click view!toolbars!drawing, nothing happens. No drawing toolbar appears at the bottom of the screen where it used to be. There's a small "drawing toolbar" icon on the main toolbar, but whether this is depressed or not makes no difference either.

I understand this may be changed in the 2007 version, but I’m using Excel 2000

It’s probably a really simple solution, but neither the help screens nor a quick google gave any solution.

Whether the drawing toolbar is checked or not, it nevers appears at the
bottom (or anywhere else). As far as I know, all the other toolbars work
just fine. Any ideas?

The drawing toolbar is visible, but the functions are not usable on any
worksheet. How can the toolbar be reactivated? NOTE - I reviewed the other
question on this topic and 1)Workbook and Worksheet are NOT protected
2)Workbook is NOT shared and 3) worksheets are NOT grouped. Also, there are
no "disabled items". If I open a NEW workbook, it has an active drawing
toolbar, thr problem appears to be limited to this one workbook. Thanks in
advance.

I am using Excel 2003 Professional
Edition SP2

I'm trying to label some plots for my thesis using the arrows and text boxes that are available on the "Drawing" toolbar.

However, whenever I try and turn this toolbar on, either by using the 'view - toolbars' menu or by selecting 'customize toolbars/settings', I get the dreaded spinning beach-ball of death (Excel freezes). Eventually I have force-quit.

I've tried uninstalling Mac Excel Expander which I've been using, and even reinstalled MS office entirely using only what comes on the install disks, but nothing seems to work.

Has anyone else seen this issue? Is this a known bug? Any solutions?

I have one possible work-around. It looks like I am able to select individual buttons from the 'customize' menu, and I could reconstruct a 'drawing' menu by tacking the individual buttons onto an existing toolbar. This is a pain since there are alot of drawing items I need.

I'm using Excel 2004 For Mac

Any thoughts you might have would be appreciated.

Thanks
Kevin

In Microsoft Excel,
Toolbars,
Drawing,
Autoshapes --> In this autoshape, all charecters and symbols of the keyboard
like,
AaBbXxZz1!=+<, should be added.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming

A user created several spreadsheets and has shared them on the network. The
problem now is that no one can use the Drawing tools in any of the
spreadsheets now. Is there a setting that needs to be changed to activate
this toolbar automatically when the spreadsheet is opened for anyone?

Hi,

Is there anyway to automatically update a value in a cell to a texbox?

Eg
In sheet1, there is a value of 2.3 in cell A1.
In sheet2, I have a textbox created from the Drawing Toolbox.
The content in the textbox would always be "Total (Sheet1.A1.value) Months"

Appreciate any advise.

Thank you,
Gon

drawing tools (like in excel) for an access form...

i would like to with some drawing objects in an access form like i do in an excel sheet (with the drawing toolbar)...?

thank you...

I wish to write a macro which depending on the value of a cell (with a drop-down), will change the colour of an object (a box created from drawing toolbar).

I need the box to have no fill colour if cell x = "National", but have fill colour 'white' if cell x = "North", "Central", "South"......plus another 13 values.

Pls can you help.

Thank you.

I have a sheet that I cannot protect since I need to allow access to drawing tools. Is there a way to force the tab to the next unlocked cell as if the sheet were protected? I am using Excel 2003.

Thanks in advance,
Laura


No luck finding an answer? You could always try Google.