Delete Current Row in protected Form

joyfulincanada · #1 04-07-2013, 08:18 PM

Now I see. Thanks!

I do like this solution but one of the issues is that the people who are going to be using this, aren't necessarily familiar with how to run macros, so I have to keep it really easy to use. Is easiest if the macro itself can prompt the user to delete or add to modify the rows.

Doug Robbins on the Microsoft forum just solved this for me:
http://answers.microsoft.com/en-us/o...=1365388494607

However, I am going to keep this solution and propose both and see what they think of it?

Thanks again!

macropod · #2 04-07-2013, 08:29 PM

Quote:

Originally Posted by joyfulincanada

I do like this solution but one of the issues is that the people who are going to be using this, aren't necessarily familiar with how to run macros, so I have to keep it really easy to use. Is easiest if the macro itself can prompt the user to delete or add to modify the rows.

The only question becomes: how do you want to trigger the macro? One could, for example, trigger it as an 'on-entry' macro attached to the first formfield. See attached. An advantage of this approach is that, if the user makes the wrong choice, the effects are easily undone via the Undo button.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete Rows in Protected Table with Form Fields	Elan05	Word VBA	23	09-11-2014 12:47 PM
Mail Merge a Protected Form Maintaining Form Fills	t/korean85	Word	1	04-07-2013 05:34 PM
Running a Macro in a protected form	yessmarie	Word VBA	1	05-25-2012 12:04 AM
Form protected in design mode-can't do anything	DrDtMM	Word VBA	12	01-23-2011 12:37 PM
Font size changes in a protected form..?	jackbkmp	Word VBA	0	03-03-2010 10:14 AM