Text Boxes in Shared Workbooks

A

Anne

Does anyone know how I can get text boxes to work in a shared workbook? Using
excel 2003
 
P

PJ

Hi Anne

Text boxes are one of the features unavailable in shared workbooks (see
Excel Help for a full list).

To insert a text box you first need to unshare the workbook.
Go to Tools|Share Workbook|Editing and uncheck the "Allow changes by more
than one user" box.
You should now be able to insert your text box.
To share the workbook again, just check the "Allow changes..." box again of
course.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top