Hide the active sheet when workbook is shared

[Raghava@rock]

hi ,


I am in need of a code which will work when the workbook is shared mode to hide the active sheet.

Plz help

 

[Hui]

Raghava@rock


Can you explain what you want to do as by hiding the Active Sheet, a new sheet becomes active?

 

[Raghava@rock]

Hi ,


I am actually creating an copy of an existing sheet (A) when the copy is created the name of the same should be changed to X. once the name of the copy sheet is changed to X i need to hide it . and code should work when the work book is in shared mode.


Thanks in advance for help