ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Suddenly can't insert text box, Why? (https://www.excelbanter.com/excel-discussion-misc-queries/17699-suddenly-cant-insert-text-box-why.html)

Fairmont

Suddenly can't insert text box, Why?
 
Worked on a spreadsheet and could insert text boxes and now I can't insert
text boxes or graphics, and the spreadsheet is not protected.

Debra Dalgleish

If the workbook is shared, you won't be able to insert text boxes or
graphics.

To turn off sharing, choose ToolsShare Workbook.
On the Editing tab, remove the check mark from 'Allow changes by more
than one user at the same time.'
Click OK
Click Yes, if you want to confirm the change.

Fairmont wrote:
Worked on a spreadsheet and could insert text boxes and now I can't insert
text boxes or graphics, and the spreadsheet is not protected.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



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

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