i used this technique but there are still issues. First, the macro doesnt work if you protect the worksheet. If you don't protect the worksheet a person can simply get the name of the hidden sheet out of a formula. Then you open a sheet, go to Cell A1 and enter IF(CALC!A1="","",CALC!A1) then drag that down and across and viola you see the hidden sheet - or at least the cell values.. Even if you protect the sheet to hide cell references from formulae you can get the hidden sheet's name from properties of controls (option buttons and so on)
For extra security you can set all text to white and password protect it with the 'select locked cells' turned off. That way even if they go into the script editor and turn it back on, the sheet still looks blank, and they can see the content of any cells.
Hi, I just try to do it, it gave me an error message saying: "Unable to set the visible property of the worksheet class" How do I go about fixing this error? Thank you.
It's because he writes it in the same line after the Keyword 'Then'. If he would use two lines instead, he needs to close the 'If-Statement' with the mentioned 'end if'
you prolly dont give a damn but does anyone know a method to log back into an instagram account? I was dumb lost my password. I would love any tips you can give me.
@Maximilian Kase thanks for your reply. I found the site through google and Im waiting for the hacking stuff now. Seems to take a while so I will reply here later with my results.