The button now works for some reason. My only problem is to keep the password box from displaying at the end of the macro.
"Dennis Marks" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >I created a macro that unlocks the sheet, copies values from one spot to >another, and then relocks the sheet. I have a couple of problems. > > 1. When I run the macro from the menu it works but at the end it stops at > the enter password to lock box. In the macro I did enter a null value and > entered it. Why is it asking for one to set again? > > I created a button and assigned the macro to mouse click. The button seems > to stay in edit mode unless I lock the sheet. Even with the sheet locked > the button does not do anything. Please give me detailed advice on how to > create a button that will run a macro. > > -- > Dennis Marks --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
