"Drawing" Toolbar is inactive

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Nosell,
One reason for the Drawing toolbar to be "greyed out" and therefore no
available, is that the sheet is protected. Unprotect the sheet and th
toolbar will activate.
If you need to protect the sheet and be able to use the drawin
toolbar, then in the "Protect Sheet" dialog box select "Edit Objects
and then protect your sheet and the drawing toolbar will be availabl
on the protected sheet
 
It is quite possible that the worksheet is Protected.

Tools>Protection>Unprotect sheet.........you may need a password.

Gord Dibben Excel MVP
 
Have you grouped sheets?

Look for [group] in the title bar.

(If the worksheet wasn't protected.)
 
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 said:
Have you grouped sheets?

Look for [group] in the title bar.

(If the worksheet wasn't protected.)
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
Click to expand...
Click to expand...
 
Sharing a workbook allows multiple users to edit it simultaneously.

If you don't need this:

Tools|share workbook|Editing tab
Uncheck that option


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 said:
Have you grouped sheets?

Look for [group] in the title bar.

(If the worksheet wasn't protected.)
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
Click to expand...
Click to expand...
Click to expand...
 
Dave, thank you so much! That appears to have solved it.

Dave Peterson said:
Sharing a workbook allows multiple users to edit it simultaneously.

If you don't need this:

Tools|share workbook|Editing tab
Uncheck that option


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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
Sharing a workbook allows multiple users to edit it simultaneously.

If you don't need this:

Tools|share workbook|Editing tab
Uncheck that option


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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Hi Deauxx

what do you mean when you say:
"But the drawing, text boxes, and drawing toolbar didn't come over with
it." - the drawing toolbar can be found under view / toolbars / drawing.

if this isn't the problem - the worksheet's not protected? the workbook's
not protected? the sheet's aren't grouped and you have not shared the
workbook?
then, how did you "copy" it ?

Cheers
JulieD


Deauxx said:
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 said:
Sharing a workbook allows multiple users to edit it simultaneously.

If you don't need this:

Tools|share workbook|Editing tab
Uncheck that option


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

:

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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top