MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Mask a spreasheet


Posted by amroo on June 15, 2001 5:27 AM

Bonjour, is it possible to mask a sheet that it can't be see in a workbook, or to bee see but protect it from writing on it.
2001 Thanks
Amroo


Posted by Ivan F Moala on June 15, 2001 7:44 AM

In the VBA Editor (Alt F11)
View Project explorer (Ctrl R)
Select the sheet you want to Hide
View Properties (F4)
Scroll down the list until you see visible.
Select the dropdown list next to it and select
2-xlsheetveryhidden

The sheet will be hiiden and will not appear
on the Hidden sheet name space.
Suggest you lock the VBA Editor as well from viewing........

HTH

Ivan