Hi, Good Morning.
maybe someone will have an Idea for the following:
I have a protected worksheet. I am trying to draw a chart on it , so after the whole flow of DialogBoxes I get an Error Message says: you can not create a chart on a protected sheet. for Unprotect use Tools--> ...etc.
I have succeeded to remove the protction by:
CommandBars(1).Controls("C&hart...").OnAction = activesheet.unprotect
Now I need to protect the sheet again when the action is ended, the chart is drawn.
How can I protect the sheet again right on the end of the action, only by Code?
Thanks for your Quick answer.....
maybe someone will have an Idea for the following:
I have a protected worksheet. I am trying to draw a chart on it , so after the whole flow of DialogBoxes I get an Error Message says: you can not create a chart on a protected sheet. for Unprotect use Tools--> ...etc.
I have succeeded to remove the protction by:
CommandBars(1).Controls("C&hart...").OnAction = activesheet.unprotect
Now I need to protect the sheet again when the action is ended, the chart is drawn.
How can I protect the sheet again right on the end of the action, only by Code?
Thanks for your Quick answer.....