Posted to microsoft.public.excel.worksheet.functions

Rick Rothstein $MVP - VB$ $Rick Rothstein $MVP - VB$ is offline$

external usenet poster

Posts: 2,202

Hide VBA code help

Rows("16:65536").Hidden = True

Using Excel 2003... this line works fine for me. It even works for me in
Excel 2007 (although it doesn't hide all the rows as Excel 2007 has more
than 65536 of them).

Rick

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
Code for button to hide/unhide rows	Chris	Excel Worksheet Functions	5	March 5th 07 06:15 AM
How to hide VB code from Excel file	Anift	Setting up and Configuration of Excel	3	December 19th 06 01:43 PM
Hide Code	tannersnonni	Excel Discussion (Misc queries)	0	July 28th 05 01:06 AM
In Excel VBA Editor, how do I hide my code from other users?	Mayberrk	Excel Discussion (Misc queries)	1	February 8th 05 06:11 AM
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 10:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us