1,336 reputation
41636
bio website blog.richardhartness.com
location Charlotte, NC
age 33
visits member for 2 years, 11 months
seen Jul 3 at 14:14

I am a software architect, living in Charlotte, NC.


Sep
4
awarded  Quorum
Sep
3
answered Is there a tool that lets me query a websites content?
Aug
30
comment Is there a way to print multiple worksheets into one document, with correct page numbers?
I know this is SuperUser (and code questions tend to belong on StackOverflow) but do you know how to do this in VBA? My users want a list box that they can use multi-select from the sections of the Excel document. This is actually a good requirement because there are a LOT of worksheets and mis-clicking, when selecting worksheets, is a very easy thing to do.
Aug
29
asked Is there a way to print multiple worksheets into one document, with correct page numbers?
Aug
28
comment How can I view the properties of a button on an Excel Worksheet?
That did it. Thank you!
Aug
28
accepted How can I view the properties of a button on an Excel Worksheet?
Aug
28
comment How can I view the properties of a button on an Excel Worksheet?
Aha! I see now. Thank you. Feel free to post an answer. After cutting on the Developer tab, I see that all I have to do is put the Worksheet in "Design Mode", much like Access and queries.
Aug
28
comment How can I view the properties of a button on an Excel Worksheet?
Unfortunately, no. This spreadsheet is worth a lot of money as a function, not just because of the data it is used to collect. I am positive there is nothing fancy going on (i.e. no special ActiveX controls.) Whatever was done to this spreadsheet was done using standard Excel 2010 tools and objects.
Aug
28
comment How can I view the properties of a button on an Excel Worksheet?
Apologies for my ignorance, the background for this spreadsheet was that it was created by a non-developer person, for a job that needed a MUCH more robust application. I'm writing the needed application but in the interim my users absolutely need some minor changes to the original spreadsheet. I've never used excel at this level and I'm a bit clueless as to how to do whatever needs to be done to make changes on my "switchboard" worksheet. I can change VBA code and forms, but this one form has me baffled.
Aug
28
comment How can I view the properties of a button on an Excel Worksheet?
@mehow: I'm not sure and no, I don't have a developer tab open. All I can say is that these buttons are on my first worksheet, they are not on a VBA form, and they located within cells but appear to "float" over worksheet. How do I open a developer tab/toolbar?
Aug
27
asked How can I view the properties of a button on an Excel Worksheet?
Aug
13
awarded  Notable Question
Jul
25
awarded  Yearling
Jul
24
revised Retina MacBook Pro 13 inch screenshot resolution is higher than built-in display
deleted 25 characters in body
Jul
12
comment how to determine which values in a given set of cells will add up to a numerical range
Oblig XKCD: xkcd.com/287 (Not exactly the same scenario but close enough.)
Jul
12
awarded  Notable Question
Jul
3
comment Where is /sys/bus/usb/devices on Mac OS X?
I haven't used libusb, but I did try to download it from Macports. It appears to have downloaded and installed properly. Try getting it through Macports and see if that helps.
Jul
2
comment Retina Macbook Pro Scaling
Related/Duplicate(?): superuser.com/questions/612492/…
Jul
1
awarded  Enlightened
Jul
1
awarded  Nice Answer