Hi Dennis,
Dennis Marks wrote:
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?
Did you record the macro? If so, possibly that step wasn't recorded...
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.
There a icon on the toolbar forms, that you can use to change from
design to user-mode. That must do it.
Kind regards,
Cor
--
- - - - - - - - - -
- Cor Nouws -
- www.nouenoff.nl -
- - - - OOo - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
