Excel file to be restricted to open in open office - URGENT

Hi

AFAIK there is no way to completely stop anyone with access to the file from opening it in whatever program they want, but you can make it a hassle.
My suggestion is to make a sheet which explains which computers your workbook should be opened on and why.
Then you hide all other sheets, if you but this code in the BeforeSave-event it might help:

Please Login or Register  to view this content.

@perimidt,

I doubt if it would work. I don't have access to Front Desk or Open Office, but I would suggest to amend your code as follow;

Please Login or Register  to view this content.

But now, the Big question is, how would you activate the hidden sheets again when the Workbook is opened?

Do Open Office Office and Front Desk recognise very hidden sheets in Excel or not?

Even if those platforms do or don't, one would still need to provide some action to reveal the VeryHidden Sheets, thus defeating the objective of absolute security in Excel.

Regards

Hi, I should probably have explained better...

I think you would just place the following code in the open event:

Please Login or Register  to view this content.

Now if Open Office shows hidden sheets then this has no meaning.

@perimidt,

Now if Open Office shows hidden sheets then this has no meaning.

Exactly my point.

See this:http://www.forbes.com/sites/timworst...on-the-planet/


Regards

Hello dingdang,

I have just stumbled upon this search regarding your issue.

http://www.ozgrid.com/excel-add-ins/xl-safe.htm

I did not test it, but maybe, if it works for you, please do let us know.

Regards.