ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   locking an excel "form" (https://www.excelbanter.com/excel-discussion-misc-queries/150373-locking-excel-form.html)

Monish

locking an excel "form"
 
Much like I can with an Access Form, I want to lock any design edit
capability for an Excel sheet (which serves as an interactive decision
process - i.e. it asks qns to help the user move down the path of the tree)
But I dont want the "tree" design to actually be changed...

....Can I do this in Excel?

Thanks!


Chip Pearson

locking an excel "form"
 
The only thing you can do is protect the VBProject. This protection is
easily broken, though, by those so inclined. Excel/VBA is not what you could
call a "secure" application.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)



"Monish" wrote in message
...
Much like I can with an Access Form, I want to lock any design edit
capability for an Excel sheet (which serves as an interactive decision
process - i.e. it asks qns to help the user move down the path of the
tree)
But I dont want the "tree" design to actually be changed...

...Can I do this in Excel?

Thanks!




All times are GMT +1. The time now is 07:19 PM.

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