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!
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!
Try this
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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?
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
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
perfect! thanks much!