How to handle the popup while macro processing?

Help Activities
, ,
1

Hi,

I am getting the popup while macro processing i.e “you can’t perform this action when the file is read only”
Kindly refer the attached image Macro popup
. Debug option is disabled in the popup.So, I am not able to check what is the exact issue and in the log I am getting “Value does not fall within the expected range”
Can some one guide me usually when this kind of popup will appears and what will be the solution for this.

Thanks in advance.
Ashnitha T

2

@jamunatj

In the macro you can include this

Application.DisplayAlerts = False

This will make sure the message boxes wont come up

Cheers

1 Like
3

Thanks for the response @Anil_G . Any idea when this kind of popup will appears.

Regards,
Ashnitha T

4

@jamunatj

When there is an error in your macro.some action in your macro is failing

Mostly the excel is opened in readonly and youa re trying to modify it

Cheers

1 Like
5

uses Paralel Activity to click on popup