gopi09_m
05-19-2008, 10:08 AM
Hi,
I have a macro in WorkBook1.xls ,which opens the WorkBook2.xls.Macro in WorkBook1.xls process the data in WorkBook2.xls.
My requirement is to not let the user select WorkBook1.xls ,it means while macro is going on when i click the WorkBook1.xls it should not get selected.
And also when user manually closes the WorkBook2.xls then the WorkBook1.xls should be enabled automatically.
Is that possbile to implement these two things ?
Regards,
Krrishna
I have a macro in WorkBook1.xls ,which opens the WorkBook2.xls.Macro in WorkBook1.xls process the data in WorkBook2.xls.
My requirement is to not let the user select WorkBook1.xls ,it means while macro is going on when i click the WorkBook1.xls it should not get selected.
And also when user manually closes the WorkBook2.xls then the WorkBook1.xls should be enabled automatically.
Is that possbile to implement these two things ?
Regards,
Krrishna