Hi,

I created the macro, also got it run automatically whenever we open a
workbook.

Now, the problem is that this data is linked to charts (Pareto Charts that
need to be sorted) and the sheets that contain this data are hidden.
The macro is working fine if the sheets are not hidden and if i hide them it
gives me an error :(

Help Please..