PDA

View Full Version : Open Office excel issue



Ruckley
06-09-2011, 07:56 AM
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.

:eek:

Kenneth Hobs
06-09-2011, 08:31 AM
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
06-09-2011, 08:39 AM
I'm not sure I understand...Could you possibly expand?