How to open excel in backend

Learning Hub
,
1

Hello,

I have one macro sheet and excel data sheet, so macro should be open in backend and i have to type alt f11 for running macro
Please help to solve this issue

1 Like
2

Hi @praveenM1 use excel application scope and uncheck the Visible property.

3

Hi @praveenM1

image
image303×537 11 KB

Regards,
Kommi Jeevan.

4

still i am unable to do that, i would like to explain my scenario i need one excel(for eg: unapprove) to be open in backend and no changes to be made and i have one more excel like 3p and i have made some changes in 3p excel and this changes will effect to 3p if unapprove sheet is open. Guide me to solution

Thanks in advance.

5

I unchecked Visible in properties panel for first excel(unapprove) in excel scope and then in Do body i have given second excel scope for 3p excel. Please guide if i make any mistakes.

7

4march2020.zip (1.6 MB)