I have a worksheet that is protected to limit user access to only unlocked cells. After data entry by the user (in one situation it's making a selection from a listbox), I use code to make calculations on their new data and then unprotect the worksheet to enter the results. I then reprotect the worksheet.
I've run into something I haven't encountered before and could use some help. Namely, things work fine unless I perform a File - "Save As" command. This automatically triggers the Listbox_Change code and gets things out of sequence. It does not seem to trigger the control with the "Save" command, only the "Save as" command. Why is it triggering this control, and more importantly, how can I avoid the trigger or exit that code if triggered by the "Save as" command.
Thanks
I've run into something I haven't encountered before and could use some help. Namely, things work fine unless I perform a File - "Save As" command. This automatically triggers the Listbox_Change code and gets things out of sequence. It does not seem to trigger the control with the "Save" command, only the "Save as" command. Why is it triggering this control, and more importantly, how can I avoid the trigger or exit that code if triggered by the "Save as" command.
Thanks