View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anon y mous Anon y mous is offline
external usenet poster
 
Posts: 6
Default Conditional unprotect and unlocking of cell range

I have a series of worksheets.

1: I have all worksheets hidden, except for a worksheet that says macros
must be anabled to properly use the spreadsheet. (It is set up as a

The intent is:

A: if macros are disabled- this is the only worksheet visible.
B: if macros are enabled- this worksheet is hidden and others are made
visible.

C: if the current filename is "original.xls", the first worksheet "request"
is unprotected and cell range C4-E7 is unlocked, then the spreadsheet is
re-protected.

D: if the filename is not "original.xls", cell C4-E7 remains locked in the
worksheet called "request".

This spreadsheet is set up as a form for users to fill out information and
keep track of data in subsequent attached worksheets. The intent is to keep
users from recycling old forms and simply making modifications- because they
make many mistakes if they do not start from a blank set of forms. This
activity, while the user thinks it saves lots of money- it ends up costing
the company thousands of dollars by these users trying to save a few minutes
of time. This above process will keep them from changing customer name,
case and project number- which essentially keeps them from recycling the
forms. The backdoor of hiding the pages and "must enable macros" to use
spreadsheet is to keep them from overriding the formulas... (none of the
users are smart enough to circumvent this approach.

Thanks


How do I go about coding this? I haven't found the resources yet to figure
this out on my own.

Thanks