Hi,

I made assign macro in sheet 1 which is linked to sheet 2.
Whenever I hide sheet 2, It wont works and says :

run-time error '1004'
select method of worksheet class failed.

Then it will open VBS array with yellow mark status need to be edited or
something.

How can I solve this problem?

Much Appreciate,
Pran