Vba code for copying a hidden sheet to a new workbook

[ckattookaran]

Hi All

I'm new to VBA coding.....

I'm trying to copy a hidden worksheet to a new workbook and i wrote a code for the same

Please Login or Register  to view this content.

So "sql" is the hidden sheet in HBR Provisioning Helper.xls and it is copied to a new Workbook, when the process is finished my active book is now is HBR Provisioning Helper.xls, but after hiding the sql sheet in HBR Provisioning Helper.xls i want to go back to the newly created book.

Can someone help me with this?

[ckattookaran]

I got it working....thank you

[teylyn]

Care to share your solution? Maybe someone else here might benefit.

cheers

[JBeaucaire]

Assuming this macro is IN the HBR Provisioning Helper.xls file, this is my suggestion:

Please Login or Register  to view this content.