Deleting Tabs

[charlee63]

Is there a way to stop people from removing tabs from a file that I send out.

I send out a file with (1, 2, 3, 4, 5, 6 Tabs), I protect the Tab info but when the file comes back people return it with (1, 3, 4, 5) only.

 

[VoG]

You need to protect the file structure.

 

[charlee63]

How do I do that. I know about Tools --- Protection. But that doesn't stop them from deleting the tab.

 

[shg]

Tools > Protection > Protect Workbook, tick Structure.

 

[jim may]

In 2007, look under Review, Protect Workbook Icon, Protect Structures & Windows