Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Pivot Table PivotItems(x&).Visible VBA error
When trying to select only a few items off of a Pivot table's field selection list, I can deselect items from the list if all of the items have been selected with a 'Show All' manually. The VBA code I use is ".PivotItems(5).Visible = False". However, if I try to select an item that is not...- piker42
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel Workbook_Open Macro freezes
I have a simple statement in my Workbook_Open macro "Sheets("GIS Labor Supplier Spending").Select" which works fine if I open a single work book or if I open a number of files with this macro from Windows Explorer. However, if I open a number of files at the same time from the Excel Open...- piker42
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Setting a 'const' variable using an IF test?
Currently I set the ADO connect string for my site into a 'constant' that is used by all the asp pages on my site. This allows me to change the database that I connect to depending on whether I am in test mode or production mode. I now want to test for which server the code is running on and...- piker42
- Thread
- Replies: 3
- Forum: Microsoft: ASP (Active Server Pages)
