none
Worksheet.ScrollArea Property - Protecting the whole worksheet? RRS feed

Answers

  • You might be better off by hiding the rows and columns outside of your data area and then protecting the worksheet (not allowing cell selection).
    '---
    Jim Cone
    Portland, Oregon USA
    http://www.mediafire.com/PrimitiveSoftware
    (Formats & Styles xl add-in:  lists/removes unused styles & number formats) - free
    • Proposed as answer by Shasur Tuesday, November 22, 2011 6:20 AM
    • Marked as answer by danishaniModerator Saturday, January 28, 2012 4:40 AM
    Saturday, November 19, 2011 11:48 PM

All replies

  • You might be better off by hiding the rows and columns outside of your data area and then protecting the worksheet (not allowing cell selection).
    '---
    Jim Cone
    Portland, Oregon USA
    http://www.mediafire.com/PrimitiveSoftware
    (Formats & Styles xl add-in:  lists/removes unused styles & number formats) - free
    • Proposed as answer by Shasur Tuesday, November 22, 2011 6:20 AM
    • Marked as answer by danishaniModerator Saturday, January 28, 2012 4:40 AM
    Saturday, November 19, 2011 11:48 PM
  • Thank you for your suggestions.

    maybe I will set the last field in column A as the only available field. that way the whole worksheet is essentially protected?

    Sunday, November 20, 2011 2:44 PM