Hi,
I am creating an excel sheet for generating graphs. Now the data for graph is in one sheet and graph gets generated in other sheet.
I want to hide the sheet containg data. I used the following code :
workbook.sheets(mysheet).Visible = false.
This works fine, but user can easily unhide it from Format->Sheet->Unhide in excel.
Is there any solution so that it asks for password to the user, while unhiding the sheet?
Thanks,
Sharad.