Protected sheets w/macros giving runtime error 1004

I created several macros objects to do simple hide columns, filter on, filter off, etc. type functions, using the Tools / Record Macro feature. Then discovered they won't work in a protected worksheet. Is there a way around this situation, other than turning protection off?

Here's an example of the code for one of them, although I get the error or every attempt to perform a macro once the sheet is protected:

Please Login or Register  to view this content.

On top of the embarrassment of not realizing protecting worksheets that include macros cause a problem, I've never written a line of VBA code in my life.

Good morning cedarhill

Originally Posted by cedarhill

On top of the embarrassment of not realizing protecting worksheets that include macros cause a problem, I've never written a line of VBA code in my life.

We all have to start somewhere

You will need to amend your code so that when the macro is run, the protection is removed, the filters are amended, and then the protection is set again. You can find out the syntax by recording the actions and editing as appropriate, but your code would look roughly like this :

Please Login or Register  to view this content.

This may change depending on what settings you have invoked, password etc.

HTH

DominicB

Hi cedarhill

Originally Posted by cedarhill

Actually, the code you provided does make sense to me, and I assume this code will have to be present with each macro I've recorded...true?

Absolutely.

Originally Posted by cedarhill

And, yes, I do have password protection on. How do I handle that?

Like this :

Please Login or Register  to view this content.

See, it's easy this coding lark isn't it ...

HTH

DominicB