ANmarS - Search results

Excel/VBA expert since Sep 1997 (20 years 9 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

3 Q & A posts tagged with view

Fri
May 14
2010

In Microsoft Office Excel, how do I get the sheet tabs to show at the bottom?


Answer

That was for Excel2003 and earlier
For Excel2007, do this
- Click on the Office Logo at the top left corner
- click on Options
- Go to "Advanced"
- Scroll down until you reach "Display options for this workbook"
- Make sure that you have the "Show sheet tabs" is checked

VBAXLMan

Friday 5/14/2010 12:01:04 AM
Thu
Apr 23
2009

Microsoft Excel - Treeview 6.0 in User form?

I have treeview 6.0 in a user form. Does anyone know how to link charts or data to the tree view, to display in a window in the user form when clicking a node? Any help would be GREATLY appreciated. Thanks!


Answer

Since you are in the VBE of Excel, you can do this

- Draw a picture box that shows when the user clicks the node
- Copy the chart and paste it as picture in some temp sheet
- Then read that picture into that picture box

This is what I have in mind right now, I think there are other ways...

Let me know what you came up with, I liked your advanced question


VBAXLMan

Thursday 4/23/2009 9:05:09 AM
Sun
Jan 11
2009

How to view more columns in Excel 2007?

I just got Excel 2007 and I can't figure out how to widen the spreadsheet to display more columns. There's an inch of grayspace on the left of the spreadsheet and four inches or grayspace on the right, yet only 9 of my 25 columns are viewable. In other words, I have to scroll left or right to get to the other columns. It's as though the spreadsheet is in a viewer that needs to be resized. Any suggestions?


Answer

Try double click the title bar of that worksheet window
If you can't, then it might be protected
When a worksheet protected mode is "Windows", then you can not resize it unless you unprotect it

VBAXLMan is back

Sunday 1/11/2009 10:07:22 PM

Tags

History