Open Office excel issue

[Ruckley]

Hi,

I have discovered that it is possible for users to load up my protected workbook in OpenOffice.org and view the macros (which are usually protected). This may be problematic and I am keen to keep the coding hidden. Is there any way of stopping it from being viewed.

any help gratefully received.

[Kenneth Hobs]

When you close the file, your macro should hide all sheets but one telling them that macros must be enabled. When it opens, the macro would hide all but the one sheet.

[Ruckley]

I'm not sure I understand...Could you possibly expand?