Hi Gary
Can you unhide the sheets during the running of the macro and then rehide
them after the task is completed.
Try putting

Sheets(1).Visible = False
Sheets(1).Visible = True

If you don't want any user possibly seeing the sheets during the operation
Also include
Application.screenupdating=False
at the beginning of the code
and
Application.screenupdating=True
at the end

HTH
Michael M

in your code

"Gary" wrote:

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..