Stuart Little
Board Regular
- Joined
- Mar 4, 2002
- Messages
- 64
Hi all
I have recorded a macro to find and replace certain values within a workbook and then open the next workbook and do the same. The only problem is that the worksheets are protected and therefore a password has to be entered before the find and replace can work.
Is there anyway to incorporate a password into the macro, so that the worksheets can work independantly.
Many thanks in advance.
I have recorded a macro to find and replace certain values within a workbook and then open the next workbook and do the same. The only problem is that the worksheets are protected and therefore a password has to be entered before the find and replace can work.
Is there anyway to incorporate a password into the macro, so that the worksheets can work independantly.
Many thanks in advance.