"Drawing" Toolbar is inactive

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 not
available, is that the sheet is protected. Unprotect the sheet and the
toolbar will activate.
If you need to protect the sheet and be able to use the drawing
toolbar, then in the "Protect Sheet" dialog box select "Edit Objects"
and then protect your sheet and the drawing toolbar will be available
on the protected sheet.


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=314596

It is quite possible that the worksheet is Protected.

ToolsProtectionUnprotect sheet.........you may need a password.

Gord Dibben Excel MVP

On Wed, 17 Nov 2004 14:22:03 -0800, 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

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

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

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

Dave, thank you so much! That appears to have solved it.

"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