VBA

Moderators: PavlinII
Number of threads: 1614
Number of posts: 3000

VBA
Forum Info
This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Edit Report
Hide a column in Excel via VBA code Posted by Chuck on 19 Sept 2000 at 12:56 PM
How would I hide a column in Excel 97 using VBA?


Reply   Share By Email Share By Email
Edit Report
Re: Hide a column in Excel via VBA code Posted by Greg Andora on 24 Sept 2000 at 9:21 PM
: How would I hide a column in Excel 97 using VBA?<br>
: <br>
<br>
<br>
Sheets("SheetName").Visible = xlHidden<br>
<br>
If you want to prevent users from making it visible again...use xlVeryHidden. This makes the property only accessible through code.


Reply   Share By Email Share By Email
Edit Report
Re: Hide a column in Excel via VBA code Posted by Benjamin Hoffstein on 17 Oct 2000 at 1:33 PM
: How would I hide a column in Excel 97 using VBA?<br>
: <br>
<br>
The other reply you got was to hide an entire sheet.<br>
<br>
Here's how I hide columns (this example hides column B)...<br>
<br>
Columns(2).ColumnWidth = 0


Reply   Share By Email Share By Email



 

Recent Jobs

Home About PH Privacy Statement Hosted SubVersion Hosted Bugtracker Contact Us Advertise Here
Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.