Posted to microsoft.public.excel.programming

RichC[_2_] RichC[_2_] is offline

external usenet poster

Posts: 1

Hide Excel row in VBA

Help! I'm using Excel 97 and I am trying to hide a
spreadsheet row using VBA. This code is not working:

activesheet.Rows("28").Hidden = True

The message is 'unable to set the Hidden property of the
Range class.' The sheet is not protected.

Any suggestions?

Rich

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do you hide/un-hide the grid lines	ED	Excel Discussion (Misc queries)	4	February 26th 13 03:22 PM
How to hide infromation in Excel?	Sarah	Excel Worksheet Functions	3	April 21st 10 12:01 PM
Want to Hide columns in spreadsheet but NOT hide data in chart.	KrispyData	Charts and Charting in Excel	1	March 20th 09 04:45 PM
How do I hide hide #REF! in Excel	PerryK	Excel Discussion (Misc queries)	3	February 27th 09 02:59 PM
How do I hide a worksheet in Excel and use a password to un-hide .	Dchung	Excel Discussion (Misc queries)	3	December 2nd 04 06:24 AM

All times are GMT +1. The time now is 06:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us