F
fiset
If I hide a worksheet and then email the entire Workbook to someone
will the recepient be able to see the hidden worksheets
will the recepient be able to see the hidden worksheets
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kevin M
Fiset, they are able to unhide it just as easily as you hid
it in the first place.
You'll need to protect the Workbook, make sure it's the
workbook and not the sheet! and password protect it.
they'll still be able to modify individual cells.
HTH
Kevin M
it in the first place.
You'll need to protect the Workbook, make sure it's the
workbook and not the sheet! and password protect it.
they'll still be able to modify individual cells.
HTH
Kevin M
F
fiset
Thanks Kevin, as a follow up (if you are reading this), if the Workboo
is protected, are you saying that THEN they won't be able to unhide
hidden worksheet
is protected, are you saying that THEN they won't be able to unhide
hidden worksheet
J
JE McGimpsey
No - if the user can open the file, then s/he can unhide your worksheet
(it may be more or less difficult, depending on how you hide it. If you
use
Sheets("Sheet2").Visible = xlVeryHidden
in the Immediate Window of the Visual Basic Editor, then the worksheet
name won't show up in the Sheets/Unhide dialog. Make sure you then
protect your VBA project (in the VBE: Tools/Properties), so that the
sheet isn't visible in the Project Browser.
This still isn't very secure - VBA passwords are easy to break - there
are lots of commercial crackers available. Even without cracking the
password, the sheet name will still be visible to anyone with a hex
editor and a bit of curiosity. It's even easier to look in formulas for
references to the sheet. Once the sheetname is known, it's easy to
unhide it.
(it may be more or less difficult, depending on how you hide it. If you
use
Sheets("Sheet2").Visible = xlVeryHidden
in the Immediate Window of the Visual Basic Editor, then the worksheet
name won't show up in the Sheets/Unhide dialog. Make sure you then
protect your VBA project (in the VBE: Tools/Properties), so that the
sheet isn't visible in the Project Browser.
This still isn't very secure - VBA passwords are easy to break - there
are lots of commercial crackers available. Even without cracking the
password, the sheet name will still be visible to anyone with a hex
editor and a bit of curiosity. It's even easier to look in formulas for
references to the sheet. Once the sheetname is known, it's easy to
unhide it.