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]
