Dear All
I have a list box with 3 options on a single protected worksheet (call it Worksheet 1)
the items in the list are in the following order call them a,b and C
When I select option a I would like to cause cells in the range
A1:E10 to become un protected and cells R1:Q10 to become protected
(both of the ranges are set as locked when the worksheet is unprotected)
when I select option b or c I would like the oposite to happen
ie R1:Q10 to become unprotected and cell A1:E10 to become protected:
does anyone:
a) Know if one can read from a listbox using VBA?
b) Prehaps have any VBA code for doing this?
Best Wishes
Thomas
I have a list box with 3 options on a single protected worksheet (call it Worksheet 1)
the items in the list are in the following order call them a,b and C
When I select option a I would like to cause cells in the range
A1:E10 to become un protected and cells R1:Q10 to become protected
(both of the ranges are set as locked when the worksheet is unprotected)
when I select option b or c I would like the oposite to happen
ie R1:Q10 to become unprotected and cell A1:E10 to become protected:
does anyone:
a) Know if one can read from a listbox using VBA?
b) Prehaps have any VBA code for doing this?
Best Wishes
Thomas