SOLVED Unable to set the Hidden property of the range class

cadence

Well-known Member
Joined
Dec 6, 2005
Messages
528
Hello all,

Run-time-error 1004
Unable to set the Hidden property of the range class

if you ever get this message and can't figure out how to solve it, let me suggest this.

It mainly comes when trying to hide columns. there are two solutions
the obvious one is
The worksheet is protected, so you'll need to unprotect it or run a routine that does it for you

The other is that you may have comments on some of the cell that are to be hidden. EXCEL DOES NOT LIKE THIS. The only solution I found was to remove the comments. Perhaps those better than I know of a work around, but blunt force did the trick.

Hope it will benefit someone pulling their hair out. (mine is growing back)
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
10 years later and this has saved me, thank you!

I had some comment boxes floating in the range which were causing this error.
 
Upvote 0
hi! I am also having this problem. I think there's no comment boxes in my workbook. I already used the "Show Comments" function of excel and there's nothing showing. But I still encounter the above mentioned error whenever my worksheets are protected. Hoping someone can help. Thanks!
 
Upvote 0
Hello all,

Run-time-error 1004
Unable to set the Hidden property of the range class

if you ever get this message and can't figure out how to solve it, let me suggest this.

It mainly comes when trying to hide columns. there are two solutions
the obvious one is
The worksheet is protected, so you'll need to unprotect it or run a routine that does it for you

The other is that you may have comments on some of the cell that are to be hidden. EXCEL DOES NOT LIKE THIS. The only solution I found was to remove the comments. Perhaps those better than I know of a work around, but blunt force did the trick.

Hope it will benefit someone pulling their hair out. (mine is growing back)
Another possibility is rogue group boxes (as was my case). To check for this, go to Home...Find and Select...Selection Pane. Unhide all rows and columns in you worksheet. Click on each name in the Selection panel and it will reveal the control for you to verify.
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,272
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top