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

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

--

HTH

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


"gaftalik" wrote in
message ...

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

That worked very well , thank you much .


--
gaftalik
------------------------------------------------------------------------
gaftalik's Profile: http://www.excelforum.com/member.php...fo&userid=6450
View this thread: http://www.excelforum.com/showthread...hreadid=479099