Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
jd jd is offline
external usenet poster
 
Posts: 91
Default How to enable items on Excel draw menu bar.

On an excel spreadsheet the buttons on the draw menu bar became disabled and
I need to enable them. I have checked permissions and can't find what is
causing this.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How to enable items on Excel draw menu bar.

Sounds like the sheet is protected under ToolsProtection.


Gord Dibben MS Excel MVP

On Fri, 9 May 2008 06:52:00 -0700, JD wrote:

On an excel spreadsheet the buttons on the draw menu bar became disabled and
I need to enable them. I have checked permissions and can't find what is
causing this.


  #3   Report Post  
Posted to microsoft.public.excel.misc
jd jd is offline
external usenet poster
 
Posts: 91
Default How to enable items on Excel draw menu bar.

Thanks for the info. I found out by trial and error that I had to go to
Tools/Options/View tab then select the Objects/Show all radio button. After
doing this, I was then able to insert and use text boxes and the other items
on the menu bar.

"Gord Dibben" wrote:

Sounds like the sheet is protected under ToolsProtection.


Gord Dibben MS Excel MVP

On Fri, 9 May 2008 06:52:00 -0700, JD wrote:

On an excel spreadsheet the buttons on the draw menu bar became disabled and
I need to enable them. I have checked permissions and can't find what is
causing this.



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How to enable items on Excel draw menu bar.

Thanks for letting us know the solution.

I missed that one.


Gord

On Fri, 9 May 2008 12:53:13 -0700, JD wrote:

Thanks for the info. I found out by trial and error that I had to go to
Tools/Options/View tab then select the Objects/Show all radio button. After
doing this, I was then able to insert and use text boxes and the other items
on the menu bar.

"Gord Dibben" wrote:

Sounds like the sheet is protected under ToolsProtection.


Gord Dibben MS Excel MVP

On Fri, 9 May 2008 06:52:00 -0700, JD wrote:

On an excel spreadsheet the buttons on the draw menu bar became disabled and
I need to enable them. I have checked permissions and can't find what is
causing this.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 97 menu items Oldjay Excel Discussion (Misc queries) 4 March 5th 08 11:48 PM
Unable to use the draw function when enable Track Changes in Excel Rudy Excel Discussion (Misc queries) 0 July 20th 07 09:42 AM
2 adobe menu items in Excel Appie Excel Discussion (Misc queries) 0 May 18th 06 08:33 AM
Remove Excel Menu Items robbybobby New Users to Excel 1 February 23rd 06 11:41 PM
Menu items added with menu item editor in older versions Michael Hoffmann Excel Discussion (Misc queries) 2 January 7th 05 01:40 PM


All times are GMT +1. The time now is 12:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"