Link to home
Start Free TrialLog in
Avatar of pg1533
pg1533

asked on

Copy data from one worksheet to hidden worksheet

Hi,

I am trying to copy the entire data from 'Data' worksheet to 'Template' worksheet. There is macro which does this job. Macor name is 'CopyToTemplate'. Macro runs when I hit Ctrl+i.

However, i would want this macro to run  when the 'Template' worksheet is hidden. I am getting an error on this. I have attached the workbook for your reference,

Please help me out on this.

Regards,
Prashanth
Dashboard-V-1.3---Copy--2-.xls
Avatar of Norie
Norie

There's a password on the VBA Project so we can't see the code.
Avatar of pg1533

ASKER

Password is 1234
ASKER CERTIFIED SOLUTION
Avatar of felixdsouza
felixdsouza
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial