1 Reply Latest reply: Aug 11, 2010 4:44 PM by Neil Miller RSS

    Locking Selection on One Sheet

      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!