Protect/Unprotect active excel worksheet in VBA

I have an excel file that has a macro that deletes and creates columns. I recently had to protect all the cells that contain formulas because end users were accidentally overwriting them.

Now my problem is the Macro will not delete the columns because they contain protected cells.

I would like to run a command at the beginning of the macro and at the end of the macro that will unprotect the worksheet then run the normal operations, then at the end of the macro I would like it to protect the worksheet again.

I found the code to protect a specific worksheet name;

Sheet1.Unprotect Password:="Secret"
Sheet1.Protect Password:="Secret"

but my macro will be ran on a number of different worksheet tabs and I don't want to have to createa a different macro for each. Is there a way to call out the ACTIVE worksheet only when the macro is ran?

Thanks!
Dan
LVL 1
filtrationproductsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rory ArchibaldCommented:
Just replace Sheet1 with Activesheet
:)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VB Script

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.