How can I create an expandable table in a protected form?

D

dgliver

I want to create a protected form for users to fill out, and I need the users
to be able to add/delete rows to a table without unprotecting the form. Can
anyone tell me how to do this?
 
S

Stefan Blom

The easiest solution is to place the table in an unprotected section of the
form; then users can add rows as they would in an unprotected table. Note,
however, that they will also be able to edit the table, which may not be
what you want.
 
D

dgliver

Stefan,

Thank you for your reply. I did think of that, but unfortunately I do need
the table to be protected also. My feeling is the functionality I want is
only possible by writing a macro, and I don't know VB. Any other ideas would
be welcome!

Greg
 
S

Stefan Blom

I suspect that you are right: a macro is needed. I believe a common
workaround is to have a macro unprotect the form, make the desired changes,
and then reprotect it, but you should ask in a programming newsgroup such as
microsoft.public.word.vba.general for more knowledgeable assistance.
 

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