[Solved] VBA : "Secure" worksheet

AlanT · Apr 22nd 2004

Hi Guys, I have read with interest the ongoing debate about securing Excel spreadsheets, and I am well aware of the limitations of creating a truly secure workbook.

With this in mind I have hidden sensitive data using the "Very Hidden" command in VBA. I think this is very useful because sheets which are very hidden do not show up in the "file properties" dialog.

However any named range contained on a very hidden sheet is still visible in the properties dialog. A user might not be able to access the named range, but s/he will know it is there.

So basically I was wondering if anyone knew of a way to apply "very hidden" characteristics to named ranges?

Cheers

Alan

Anonymous · Apr 22nd 2004

If you set the Visible property for a name to False, the name won't appear in the Define Name dialog box.

**Andy Pope** · Apr 22nd 2004

Hi Alan,

Use some code to make the Named range invisible.
So for a range named Alan use,

names("Alan").Visible = False

Cheers
Andy

Derk you're TDQ ;;)

AlanT · Apr 22nd 2004

Thanks guys, is there any way to do this for all ranges at once?

Anonymous · Apr 22nd 2004

This will hide them all.

Code

Sub HideNames()
    Dim n
    For Each n In ActiveWorkbook.Names
        n.Visible = False
    Next n
End Sub

Egad · Apr 22nd 2004

You should never hide sensitive data in a workbook.
Data on Very Hidden sheets can be seen in seconds (point & click) with no special skills or crack software.
Am I allowed to say how?

[Solved] VBA : "Secure" worksheet

Participate now!

Share