Loop Macro + Very Hidden Sheets = Tricky?

Hi All,

I am running a loop macro on over 400 workbooks from my Personal.XLS file. For the most part, I have no problem deleting rows, adding columns, etc.

However... one of my tasks involves unhiding a "Very Hidden" sheet from each file, adding a name to that hidden sheet, and then re-very-hiding that sheet.

But, running the code gives me an error that says "Invalid Outside Procedure," while highlighting the "ThisWorkbook.Sheets("NAMES").Visible = xlSheetVisible" line

Is this happening because I'm running the code from Personal.XLS... but I want to unhide a sheet from a different file?

Anyone know how I can get around this? Thanks!!

Best,

Lilanngel

Works perfectly. Thank you!!

Thanks for posting informative, but try to give complete macros here, as in our office v cannot download except to view web.