Is it possible to create a custom tab in excel containig a checkbox showing de protection state.
Checkbox checked if worksheet is protected and unchecked when worksheet is not protected.
I was thinking of a worksheet_activate procedure but how do I control the checkbox in the ribbon using vba ?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.