Can anyone help please?
I using an excel workbook (master1) with a macro which opens a sequence of excel workbooks within a specified folder. For every workbook the macro
Here is the code
Windows(fname).Activate
ActiveSheet.Unprotect
Here is where it stops and make me enter the password manually
Would be very grateful for any help
Thank you very much
Alison
I using an excel workbook (master1) with a macro which opens a sequence of excel workbooks within a specified folder. For every workbook the macro
- opens each workbook readonly,
- copies a range of data from the activesheet onto a datasheet 'master1'
- closes the workbook
Here is the code
Windows(fname).Activate
ActiveSheet.Unprotect
Here is where it stops and make me enter the password manually
Would be very grateful for any help
Thank you very much
Alison