H
homework_seattle
I have a user worksheet with two columns for "item" and "qty".
I have a short version with 10 rows hidden and a macro button that
opens up the long version by un-hiding the 10 rows. I can Protect the
sheet but get VB 400 error when clicking button to open long form and
the area around the 10 rows is highlighted, like Protection is not
allowing unhiding.
Help? Workaround? Onerror...?
Thx.
I have a short version with 10 rows hidden and a macro button that
opens up the long version by un-hiding the 10 rows. I can Protect the
sheet but get VB 400 error when clicking button to open long form and
the area around the 10 rows is highlighted, like Protection is not
allowing unhiding.
Help? Workaround? Onerror...?
Thx.