Hide Worksheet Macro shows data before password prompt

Just getting my feet wet with Macros, need some help with one I found on the web.

I use a macro that hides data on a worksheet yet keeps that sheet tab visible. When I need to access the tab, it prompts for a password. See attached sample file. Password is "password" (no quotes).

Works well but when I click on the tab of the 'hidden sheet' the data flashes on screen momentarily as the password prompt appears. Worse yet, if you click and hold on the 'hidden sheets' tab, the data stays visible until your release the mouse button.


How do I get the data to NOT appear when accessing the hidden sheet?

Here's what we have:

Please Login or Register  to view this content.

Thanks, Steve

Macro Credit to Mike H, at
<http://answers.microsoft.com/en-us/office/forum/office_2003-excel/hiding-a-spreadsheet-within-a-workbook/1159ad78-ca37-4bf7-83a4-ab87667c994f>

This is a little different but I think it does what you want. It hides columns A:Z on Sheet1 until the password is entered.

Please Login or Register  to view this content.