cannot edit a macro on a hidden work book in excel 2011 in mac

VikasAgni1955 Why don't you use vba to unhide the workbook, complete the action(s) desired, and hide the workbook again?

Hi VikasAgni1955 

Could you please attach the screenshot for better understanding and can you describe more about the issue? 

Regards, Faraz Shaikh