Sharing Excel & Using Textboxes

Question

Hello,

I know that the textbox feature is turned off when sharing an Excel file.  I'm just wondering if there is anyway to overcome that.

Answer 1

When I mentioned that text box controls were ActiveX controls above I was correct but you are using the shape text box, not the ActiveX control.

The limitation still applies: they are disabled when sharing.

There are no alternatives of which I am aware.

Workbook sharing is also not reliable and is known for causing workbook corruption.

Will the users be OK without sharing the workbook?

If not, then you will have to come up with something more creative such as formatting a range of cells to act as the bulleted notes entry area.

Kevin

Answer 2

Hello,

Textbox is the preference of the spreadsheet users since it offers more formatting functionality vs. a cell.  Or textboxes are easier to use for the spreadsheet users for formatting vs. making format changes in a cell.  They want to use things like bullets or indenting, etc. 

On the userform front, I haven’t educated myself enough to bullet a userform.  However, all people will want to do is type in the file for userform, like in Microsoft word.

Answer 3

Don't use the text box control is the most obvious solution. It's an ActiveX control anyway which is known to cause problems such as workbook corruption.

Why are you using text box controls when data can be entered directly into a cell?

Have you considered using user forms?

Kevin