Toolbar problem !

[gaftalik]

Hi all ,

I have a sheet in which the icons on the menu toolbar; merge a cell;control toolbox toolbar;chart and scenarios are all disabled (unhighlighted and could not be clicked )
After trying to click on the VBA project of that sheet under view code it returns an error saying the project is locked.
How can i make those icons on the menu toolbar work ?

Thank you very much .
_________________

[Bob Phillips]

Sounds like the workbook is shared. You will need to unshare it (Tools>Share
Workbook... and uncheck the box) to get at these options.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"gaftalik" <[email protected]> wrote in
message news:[email protected]...
>
> Hi all ,
>
> I have a sheet in which the icons on the menu toolbar; merge a
> cell;control toolbox toolbar;chart and scenarios are all disabled
> (unhighlighted and could not be clicked )
> After trying to click on the VBA project of that sheet under view code
> it returns an error saying the project is locked.
> How can i make those icons on the menu toolbar work ?
>
> Thank you very much .
> _________________
>
>
> --
> gaftalik
> ------------------------------------------------------------------------
> gaftalik's Profile:
http://www.excelforum.com/member.php...fo&userid=6450
> View this thread: http://www.excelforum.com/showthread...hreadid=479099
>

[gaftalik]

That worked very well , thank you much .