Good day, I would like to lock cells that have got formulas inside but that is not possible as those cells are hidden or shown through a Visual Basic code and so when I lock those cells and then apply the Visual Basic code to hide or show the same cells the following message appears: There was an error "1004" at runtime: You can not assign the Hidden property of the Range class. Summarizing I would like to lock cells that contains formulas inside, without the message error described above. Thanks in advanced and I look forward to hearing from you.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Lock cells that have got formulas inside applying a Visual Basic Code that hide or show those cells.

Thread starter DiegoAlejo
Start date Jun 17, 2014
Tags

advanced excel lock cells visual basic

DiegoAlejo

New Member

Jun 17, 2014

Good day,
I would like to lock cells that have got formulas inside but that is not possible as those cells are hidden or shown through a Visual Basic code and so when I lock those cells and then apply the Visual Basic code to hide or show the same cells the following message appears:

There was an error "1004" at runtime:
You can not assign the Hidden property of the Range class.

Summarizing I would like to lock cells that contains formulas inside, without the message error described above. 
Thanks in advanced and I look forward to hearing from you.