Unable to set the Hidden property of the Range class

**crimzon** · 03-19-2014, 01:01 AM

I locked the cells on Sheet1 from B4 to B10.

I protect the Sheet1 Review > protect sheet and selected two checkboxes from protect sheet property "Select locked Cell" and "Select unlocked cells".

It is working fine and it does not allow the user to view the locked cells B17:B24 while protection is on.

I have a RadioButton1 on the same Sheet1 and i put the following code behind the button to hide the 4 up to 10 rows. When i will press the button while password protection is on; it is giving me the following error: Unable to set the Hidden property of the Range class.

Kindly help in this issue.

Please Login or Register  to view this content.

**HaHoBe** · 03-19-2014, 01:18 AM

Hi, crimzon,

unprotect teh sheet prior to running the command and protect after or protect the sheet with teh volatile parameter UserInterfaceOnly:=True which would allow macros to run when applied (but only for the session when this command has been executed).

Ciao,
Holger

**crimzon** · 03-19-2014, 01:33 AM

Originally Posted by HaHoBe

Hi, crimzon,

unprotect teh sheet prior to running the command and protect after or protect the sheet with teh volatile parameter UserInterfaceOnly:=True which would allow macros to run when applied (but only for the session when this command has been executed).

Ciao,
Holger

I cannot give the password to anybody to unprotect the sheet first and than run it and protect it again with you own password. This is not the way to handle the situation.

**HaHoBe** · 03-19-2014, 01:40 AM

Hi, crimzon,

who said you should do so? I said unprotect in the code, run the code, protect:

Please Login or Register  to view this content.

Besides: protecting the sheet is not the protection you imagine it to be.

BTW: no need for full quotes.

Ciao,
Holger

**crimzon** · 03-19-2014, 02:16 AM

Please Login or Register  to view this content.

In this case when i tried to pass parameters in Dropdown list or i want to perform another action; it says the sheet is protected. what shall i do now?

**HaHoBe** · 03-19-2014, 01:02 PM

Hi, crimzon,

the prefix to this thread says Solved yet your question stands as posted. Without knowing what your dropdowns should trigger I would guess that you unlock those cells or attach a sample of the workbook to have a look. If I lock a sheet that´s would I would expect if I try to alter anything on the sheet.

Ciao,
Holger

**crimzon** · 03-20-2014, 02:21 AM

Originally Posted by HaHoBe

Hi, crimzon,
or attach a sample of the workbook to have a look.

Thanks for you reply!
Yes, i didn't get the answer of my question yet. I put it back to unsolved.

Kindly check the attached XL file, when you will try to change the Drop List on the sheet; it will not allow you to change and it will say that sheet is protected.

**HaHoBe** · 03-22-2014, 02:02 AM

Hi, crimzon,

the original request has been solved and you have started a new thread with http://www.excelforum.com/excel-prog...g-vb-code.html where the problem should be solved.

I´d recommend to check out Data/Validation instead of using DropDowns.

Ciao,
Holger

Unable to set the Hidden property of the Range class

LinkBack

Thread Tools

Rate This Thread

Display