That would be great. Thanks so much!
--
Tim at Alliant


"Michael" wrote:

Have you check on the excel Objects like your worksheets in the Visual Basic
Explorer, it could be attached to the OnOpen Event, or maybe attached to a
control form.
If you are not familiar with that area I'll will gladly post some steps on
how to check it.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Tim at alliant" wrote:

Thanks Michael, All of the cells are protected and unprotected correctly
however the spreadsheet was altered so the range of cells that are now
unprotected has changed. The Macro requiring that specific range of cells be
populated with data is still looking at the old range of cells prior to the
spreadsheet being changed. I believe I can fix it if I can get into the
Macro and edit the range of cells, however, the Macro seems to be missing as
nothing appears in the macro when I try to edit it.
--
Tim at Alliant


"Michael" wrote:

Select one of the cells you are refering to in your posting, the right click
on it , click on Format Cells, the select the Protection Tab, and verify the
locked check box has a check mark if you want it protected and that it doesnt
if you want it unprotected. This setting works in conjunction with the
Protect Sheet command set in the Main Menu:
Tools - Protection - Protect Sheet
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Tim at alliant" wrote:

Please help, I am working on a spreadsheet that has a Macro that requires
all unprotected fields to be filled before the spreadsheet can be saved. The
spreadsheet has been altered so the range of unprotected fields has been
changed. I cannot find the macro to edit the range of unprotected cells and
therefore cannot save the spreadsheet. Nothing appears in Visual Basic. Any
ideas?
--
Tim at Alliant