hidden columns

Hello! I would like a button to be pressed that would hide specific columns. Once the button is pressed again, the columns appear. I'm extremely new to VBA, so I'm not sure of code syntax just yet. Private Sub CommandButton1_Click() Columns("D:G").Hidden , Columns("AF:AG").Hidden...

I am using 2007. I have a set of data I am trying to display with a Pivot chart. I have a report filter for different departments and my horizontal data is dates, vertical is number of tickets opened per day. When i change the department, the dates when no ticket was opened goes away. I want...

Hi all, I have a database and a few hidden columns and right now i'm using vba to insert new records via a userform. Whenever a new record is inserted via the userform i use codes to draw the borders. However, the hidden columns doesn't have the borders drawn when i unhide the columns. Any...

Hi, I have one column for each month of the year, and all upcoming months are hidden. Each month I then go in and unhide the hidden columns, and re-hide everything but the next month: e.g. in March Jan Feb (Mar Apr May June July................) Unhide all hidden...

I have a spreadsheet with hidden columns, say, columns B and C. When I write a formula is column D that points to column A, Excel will automatically unhide columns B and C while I'm writing the formula. How do I keep columns hidden while writing formulas? This has never been an issue before...

The subtotal function can be set to ignore hidden rows. Is there a similar function that can be set to ignore hidden columns?

Hi, I just attended a webinar and thought of a question about 10 minutes after it was over. After you hide columns, how do you make sure they are still included when you sort the rest of your sheet? We have lists of employees with their titles, office, hire date, ID number, etc. It is...

I might have hit a wrong key or button, which caused a part of the current sheet not being displayed. First column shown is C, but cols A an B are still in the sheet. How can I get cell A1 in the left hand corner again? Thanks for your help. Paul

Hello: Our company utlizes a shared Excel 2003 workbook. When I unshare and make changes to the workbook, including hiding some colums in the worksheets. When workbook is shared again the columns that had been hidden in the individual worksheets are displayed again. Any help or advice on...