PDA

View Full Version : Protection



rachell_8
08-10-2010, 12:05 AM
Hi, can someone please please help me protect the attached file I created. I want Index tab to be invisible. Also, I want VMDForm tab to be protected without destroying my formulas,macro, and dropdowns. Thanks!:thumb

xld
08-10-2010, 12:52 AM
Try this

rachell_8
08-10-2010, 04:14 AM
thanks xld! appreciate your help on this. may i please know how you hid the Index tab (and how I could bring it back)? How did you hide the rest of the cells and rows?

xld
08-10-2010, 04:26 AM
Index Tab: In the VBIDE, select that tab in the project explorer, then set the visibility property in the Properties window.

Rows, and columns, Format Cells>Hide & Unhide>Hide Rows/Columns

rachell_8
08-10-2010, 05:14 AM
perfect! thanks much!:clap: