Hello,

I am trying to create a spreadsheet in excel 2003, which has a toggle button on it. When I press the button, I want the sheet to display two different sets of data, for example, display data in ColumnA and hide ColumnC and vice versa.

I am also trying to add protection to the sheet so that when ColumnA is shown, the rest of the sheet is protected, so no data in ColumnC can be deleted accidentally.

I think it should be really easy, but I cannot get it work.

Can anyone provide any assistance?

Thanks in advance.