There's no way to realistically compile your Excel file to an executable.
You might consider changing the design of your sheet so that

1. the data is as separated as possible from the rest of the functionality
2. any vba code is in an add-in or separate file

In addition, there are (at least in later version of Excel) some quite
specific modes of protection which would allow some changes but not others.

If the types of changes users need to make are consistent, you could also
look into providing a macro or series of macros which would (eg.) add
columns/ranges instead of having the users do it themselves.

Tim



"Shuvro Basu" wrote in message
ups.com...
Hi All,

I have a lot of excel sheets that containt formula and macros. They are
distributed among different departments who enter the data and send
them back to me for collating all the data into a report. The problem
is : the users frequently meddle with the formula and macros. I've
tried to password protect the cells/macors, however it becomes an issue
when there is a need to change the formula range or macro to include
more columns, ranges etc. I then have to send them the password and
they will then modify the the formula to suit their needs.

Also, the files run into large ones (usually greater than 100MB) at
times.

I would like to know if there is a way we can compile the xls sheet/
workbook into an exe so that it would be more secure and also compress
the xls sheets. I know of the commercial xls compiler(DoneEx XCell
Compiler). I will greatly appreciate if someone would/could point out
the source to a similar program.

Looking forward to your respones.
Thanks & Regds