Locking Selection on One Sheet

[#1]

I have written a macro so that when you go to one sheet within the application, a selection is automatically applied and upon leaving the sheet, the selection is removed. I'm wondering if there is a way to lock that selection while on the sheet so that the user cannot inadvertantly "clear all selections" and remove it? There are a lot of items on the page so I'd prefer to not have to apply set analysis to all of it, but realize that might be the only option.

Thanks in advance for any assistance!

[#2 · Accepted solution]

In your macro, after you make the selection, add this line:

ActiveDocument.Fields("FIELD").Lock

That will lock in whatever you have selected on that field.

I think Set Analysis probably the better way to do, but it's obviously not the only way.