Bob, I apologize for my last post. I mis-read your previous post. When you said, "Record Data" button, I mis-read this as "Record Macro" button. So, I thought you were getting this message when you were trying to Record a new Macro. That's why I thought this was a real wierd one.
Now that I see that you have a Macro Button on your worksheet labeled "Record Data", I now understand your issue. Sorry!
Fortunately, this is an easy fix.Maybe you have figured it out already. If you RIGHT-CLICK on the "Record Data" button and select ASSIGN MACRO, you will see that the button has a macro assigned called #N/A. But, this is not a macro in the list of available macros to run. So, all you have to do is select which macro of the list of available macros you want to execute when you hit this button. I assume you want the "Sheet1.Update_Model_Value" macro. Once you have made this macro assignment, then it should work for you. ... Holler back if this doesn't fix it or if you have further issues. Take care, Joe.
Bookmarks