How to allow Macros on a protected worksheet in Excel | Excel On The Go

★ Want to automate Excel? Check out our training academy ★

★ About this video ★
In this video we show you how to easily enable macros on an protected excel worksheets.

★ Download 30 most useful Excel VBA Macros ebook for FREE ★

★ Where to find Excel Off The Grid ★

#MsExcel #PowerQuery

[Matt-pwtg]

Great video.
Does this work if I have more than one sheet in the workbook that is protected. I had it running properly for one sheet but when I protected the second sheet it stopped working.
Any help appreciated 😀

[mr.write]

omg i tried it now and its working men you save me lol.. Some of my codes didnt work on unprotect prot method but this one does . lol thanks a lot bro! this method is so rare and simple. i fortunately click your video !!

[ianinholland]

Thanks, I've been unprotecting & reprotecting for years - this is so much better! Really grateful for the tip.

[houstonsam]

Many thanks, this will be extremely helpful for the development projects I take on, including one I'm finishing up right now.

[ahasanularefin]

Many thanks for this valuable content. Great job!!!

[kayleighf.]

I got it to work! Sorry if you read my last comment about how I was disappointed. Thank you. I will be looking into more of your work. Thanks so much.

[CovertOps]

I really need some Excel advice as I'm still learning.

I need to protect a sheet with an existing macro. The macro auto adjusts the row height subsequent to a search by keyword search bar. I used a FILTER ISNUMBER SEARCH formula.

I'm planning to share the workbook later, hence the need to protect it.

The cells with the formula are also the ones that the macro adjusts. Is this a dead end?

[LordBransty]

You're a godsend. I've subscribed.

[IvanCortinas_ES]

Excellent channel Mark. Excellent contents. Interesting, powerful, useful... Thank you!!!

[scottrochford]

Hi mate, I am getting runtim 9, script out of range. I cannot work out why. Sheet name etc is correct. I have sent you a screenshot to your PM's.
Any help would be great!
EDIT: I cannot send you a PM on youtube :(

[danielosorio]

I'm wondering if something has changed in Excel related to this topic about running macros in a protected sheet. I have a worksheet with three sheets: raw data, a sheet with buttons to run individual macros in a specific sequence, and a sheet with shapes showing calculations done through some of the macros on the raw data, and within this sheet a button to one-click run all macros in the specific sequence.

I protected every sheet and yet without the step suggested in this video, all macros run.

Am I missing something? Please keep in mind I am new to macros trying to make my way through them.

[mr.write]

This is my main problem i have a very complex macro.. if i protect and unprotect it will ask everytime i do something with password . Ill try this tomorrow

[minamishail_Tech]

Can we do a similar process when we work with externally protected workbooks, using power query or VBA?

[iknow]

It works. However my use case is when 50 ppl using the same excel, then this unprotect protect looks like to cause an issue of "workbook looked by someone else", which end up me not being able to deploy new excel version (overwrite the same excel file).

No way out at this moment. I can only unprotect all sheets at this moment.

[Robbiea]

And the best thing with this property is that it allows sorting locked cells throu VBA! So you don't need to unprotect your worksheet every time you want to sort in VBA procedure.

[bethjovi]

How did you add the sub called allow macro? It showed up on your video but how did you get it in there?

[lubna]

Thank you a lot but why I don’t get debug choice?

[KaylaShannon-xm]

This trick isn't working for me: I have a Query Refresh attached to a macro button, but once the sheet is protected it's not able to refresh? UserInterfaceOnly:=True is also highlighted in red, but I'm unable to add the apparent comma and underscore in the code that's shown?

[mr.write]

Bro i wanted my workbook to be protected everytime. I just allow some ranges to open. The problem is i connected my macro on multiple sheets. The problem is how can i deactivate 2 ranges from a different sheet at the same time. Allow ranges has different password on my workbook.

[sheikhayaz]

Hi
Macro working is good
But xls file closed and after macro message debug
So please. Send me answer
Thank