Hello Folks,

i have written an application to make Quotations in a printing shop. It runs well in single user environment, but my boss "suggested" to make it run in the shop´s internal net. My problem is that my application protects an unprotects several very hiddensheets at different moments. I learned from other postings that a shared document can´t be protected or unprotected via macros. One posting suggested to put all the code in another workbook and make the liassons to the original workbook in order to function.

I have still doubts on how to procced, because i need to impede to some users the access to certain areas of the sheets contained in the WKB and allow the admin (my boss) the access to make certain changes in the parameters (and cells) and then close the access to the cells again. Could any one give some advice on what kind of strategy should i follow (besides telling my boss its not possible ;P ) ?

Any help will be appreciated

Thanks

Joe Louis