ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Insert Ribbon mostly disabled (https://www.excelbanter.com/excel-discussion-misc-queries/250011-insert-ribbon-mostly-disabled.html)

Kim

Insert Ribbon mostly disabled
 
Using Office 2007 Pro w/XP. While making a lot of changes to a copy of an
existing workbook I noticed I couldn't not insert a Text Box. Upon further
review it appears the Insert ribbon has most of the buttons disabled. I was
protecting sheets/adding edit ranges etc. when this may have occurred. I've
uprotected everything, deleted the edit ranges but can't get back to previous
good state. Any ideas where I could check?

Thanks for you help.

Kim

Arceedee

Insert Ribbon mostly disabled
 
Is the workbook shared?

"Kim" wrote:

Using Office 2007 Pro w/XP. While making a lot of changes to a copy of an
existing workbook I noticed I couldn't not insert a Text Box. Upon further
review it appears the Insert ribbon has most of the buttons disabled. I was
protecting sheets/adding edit ranges etc. when this may have occurred. I've
uprotected everything, deleted the edit ranges but can't get back to previous
good state. Any ideas where I could check?

Thanks for you help.

Kim


ADB_Seeker

Insert Ribbon mostly disabled
 
Kim,
Use Excel Help (F1) and search for insert ribbon. The first option "I can't
see a command on the Ribbon" may have the answer you are needing.

"Kim" wrote:

Using Office 2007 Pro w/XP. While making a lot of changes to a copy of an
existing workbook I noticed I couldn't not insert a Text Box. Upon further
review it appears the Insert ribbon has most of the buttons disabled. I was
protecting sheets/adding edit ranges etc. when this may have occurred. I've
uprotected everything, deleted the edit ranges but can't get back to previous
good state. Any ideas where I could check?

Thanks for you help.

Kim



All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com