Thanks Steven,
I successfully managed to get the results using your approach thanks a lot for the explanation.
Dear SHG,
Please elaborate in the context of the existing code, how would i be able to use your code because I want to understand both the options even though my task is achieved.
My intention was to actually not activate the sheets and still be able to change the GRIDLINES from Viewable to HIDDEN from the parent sheet.
Please refer post# 7 to modify the approach..
Thanks in advance SHG..
Bookmarks