Search results for query: *

Hi, everyone. Question. I've got a macro that creates a text box in a chart, then exports that chart. The text box doesn't appear in the export if I export it during the macro. However, if I export the graph after the macro has finished running, the text box is included. Everything else...

Stupid question -- somehow, my menu and tool bars in the VBA editor in Excel got turned off. I can't figure out how to turn them back on. Any help would be greatly appreciated. Aaron

Question for the gurus. We have an excel file that we want to be able to "time bomb", so that it can't be opened without a password after a certain date. The file still needs to be able to be opened (if we have the password). We've figured out one way to do it, but it requires that...

Hi. How do I access/start the label wizard from Visual Basic? Or better yet, directly from a Switchboard. I have a database driven by switchboard menus and I'd like for my users to be able to click on a button and get directly to the label wizard, as the size/layout of labels will be changing...

hi, everyone. alright, this is a silly question, and I should know how to do this, but it's the holidays and my brain is fried. when i'm inserting a hyperlink inside an excel sheet pointing to a cell or name (say, cell C41), once you click on the hyperlink, it takes you to cell C41, but cell...

Hi, everyone. I'm in the process of setting up a form which has both a primary and subform embedded within it, linked based on a primary key of MemberID. I also want to create a button that links to a different subform (a pop-up form). However, I need that subform to be automatically linked...

Hi, everyone. I have a cell that looks like this: Title Text1 Text2 Text3 There are hard returns between each line. I want to write a macro to edit only the second through fourth lines of the cell and change the font size on it, but I can't figure out how to only address part of a cell with...

Hey, guys. I have two graphs that represent similar data for different organizations. I apply a custom graph type to the graphs and 95% of the time this works fine; I also stabalize the major unit, max & min on the axes, so they are the same for both grapsh Every once in a while, though, one...

Hi, everyone. This is probably more of a philosophical point, but I'm curious how you all have dealt with it. I have a series of graphs with a combination of negative & postive values. I want to report both the value of the bar (-4.5%, for example) and have the label show. The problem is...

Hi, everyone. Quick question. I have an embedded object on a hidden worksheet that I want to be able to access. Before I hid the sheet, this code worked: Sheets("DataSheet").Select ActiveSheet.Shapes("Object 2").Select Selection.Verb Verb:=xlPrimary...

Hey, guys. This is a basic question, but I can't seem to figure it out. I have a script that adds a textbox to a graph. The data in the textbox should look like this: Joe Shmoe - a - b - c For some reason, when I'm creating the string (even using either Chr(13) & Chr(10) & Chr(13) or...

Hi, everyone. I'm working on a macro that compares values between two workbooks. I know the code to do the comparison is correct (I've used it on worksheets in the same workbook, but I'm having trouble making it work across workbooks). The code excerpt is below. Any assistance would be...

Hi, everyone. Quick question. I have a range of values 5 2 0 8 0 2 3 I want to take the average of the non-zero values (i.e., average should be 4, not 2.85. Any ideas? Thanks, Aaron

Hi, everyone. I'm in the process of writing a macro that basically handles a decisions tree. I've got data like this: In excel file "Test1.xls" Name B Sig Rent .25 .01 Own 1.2 .15 Parents .22 .78 In excel file "Test2.xls" Name...

Hi, everyone. Quick question for you. I'm creating a bar graph in excel with approximately 200 items on it. These items are actually in two groups, and I need to color half of them in white and half of them in black. However, I don't want to run the chart with two series, because I want to...

Hi everyone. I'm trying to write a macro that will select all cells from a specified range where one specific cell in the is <.10, then move those cells elsewhere, and perform some functions on them. I'm comfortable writing the code to move the cells and perform the functions I need, but how...

Hey guys. I got an odd question from someone in my office the other day and I wanted to see if anyone had any suggestions. He wants to be able to count the total number of shaded cells in a row and/or column. I'm comfortable using the count functions, but I'm clueless how to approach this to...