Unable to Run VBA

To unhide before running: Right click on the sheet names at the bottom of the page, select UNHIDE, then pick the right sheet.
To unhide in the code: at the beginning of your macro, add

Sheets("instert-sheetname").Visible = True

then to rehide it,

Sheets("insert-sheetname").Visible = False

If you don't want any of this to be seen by the users, add this to the top of your macro:

application.screenupdating = False

and this to the end

application.screenupdating = True

-- this will prevent the screen from updating while the macro runs

Hope this helps!