ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Run-time Environment (https://www.excelbanter.com/excel-programming/431107-excel-run-time-environment.html)

rick

Excel Run-time Environment
 
I have developed many applications using Access and distribute them with the
run-time environment. This is my first foray into Excel and would like to
use the same approach BUT I can't see from going to the MS Office or MSDN
sites that such a deployable environment exists.

Is there a run-time for Excel (removes the design/development capabilities)
or is there another approach I should be taking? The recipients of the
application will be those seeking grants to do research and are usually from
developing countries.

Thanks for your (anticipated) reply.


... rick


Jim Thomlinson

Excel Run-time Environment
 
No such thing...
--
HTH...

Jim Thomlinson


"rick" wrote:

I have developed many applications using Access and distribute them with the
run-time environment. This is my first foray into Excel and would like to
use the same approach BUT I can't see from going to the MS Office or MSDN
sites that such a deployable environment exists.

Is there a run-time for Excel (removes the design/development capabilities)
or is there another approach I should be taking? The recipients of the
application will be those seeking grants to do research and are usually from
developing countries.

Thanks for your (anticipated) reply.


... rick



Neptune Dinosaur

Excel Run-time Environment
 
You can lock people out of the Design/Dev environment by going intro the VBA
editor and choosing Tools --- VBA Project Properties --- Protection, and
ticking the "Lock project for viewing" checkbox (and putting in a password).

You can protect worksheet formulae by protecting and passwording worksheets
(but you would have to unlock any cells that are supposed to take user input
or which are control cells for option buttons or checkboxes).



--
Time is just the thing that keeps everything from happening all at once


"rick" wrote:

I have developed many applications using Access and distribute them with the
run-time environment. This is my first foray into Excel and would like to
use the same approach BUT I can't see from going to the MS Office or MSDN
sites that such a deployable environment exists.

Is there a run-time for Excel (removes the design/development capabilities)
or is there another approach I should be taking? The recipients of the
application will be those seeking grants to do research and are usually from
developing countries.

Thanks for your (anticipated) reply.


... rick




All times are GMT +1. The time now is 11:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com