Search results for query: *

What type of check boxes? Forms or ActiveX? Cheers, Glenn. Beauty is in the eye of the beerholder.

If you rename your Personals as something else, and then do Macro Record to Personal, that should create a Personal that you can copy all the modules to. Cheers, Glenn. Beauty is in the eye of the beerholder.

I'd say that it's a Sharepoint question ... are Excel documents able to be directly linked to Excel Sharepoint storage? I'd guess not. Cheers, Glenn. Beauty is in the eye of the beerholder.

Is the list sorted so that all the cities are grouped together? Cheers, Glenn. Beauty is in the eye of the beerholder.

Can you show the xml for the button? What have you set the label as? Cheers, Glenn. Beauty is in the eye of the beerholder.

I put the data like this: w/o proc 2503 T-Hosp w proc 590 O-Hosp w proc 888 created a pie of pie, selected the lesser pie, pressed Ctrl-1, and chose to have the last 2 points as pie of pie. Cheers, Glenn. Beauty is in the eye of the beerholder.

I think pie of pie is best to show this, but I don't agree on what you think the chart should look like. I think the main chart should show w/o proc ( 62.9% ) and other ( 37.1% ), and the pie of pie should show T-Hosp w proc ( 22.3% ), and O-Hosp w proc ( 14.8% ). That is also very simple to...

Hey Skip, I should have realised that you'd covered that in the FAQ :-) Cheers, Glenn. Beauty is in the eye of the beerholder.

Hi Fee, good idea, and, for info, the shortcut Alt-D-P also works for this. Cheers, Glenn. Beauty is in the eye of the beerholder.

What is the formula that works on the same worksheet? What is the formula that doesn't work? Cheers, Glenn. Beauty is in the eye of the beerholder.

I just wanted to find out whether you had inserted a Module into your workbook. That's the kind of object the referenced post talks about. Maybe someone else on here can see your code and help out ( I can't see it due the firewall here at work ). Cheers, Glenn. Beauty is in the eye of the...

How do you display your userform ... i.e. what code performs the Show of it? Where is that code stored? Cheers, Glenn. Beauty is in the eye of the beerholder.

One way is to have a personal macro to do an action, and then customize the QAT, Select Macros in the "Choose Commands From" drop-down ( that's where it is in Excel 2007 ), click the Add button to add the command to the QAT, and with the command selected in the right-hand pane click the Modify...

thanks for the stars :-) I'm glad that my know-how is useful for others. Cheers, Glenn. Beauty is in the eye of the beerholder.

I should have spotted that, but without knowing the actual error message, I didn't even look ( always give full information in a posting ). I'm glad you figured it out :-) Cheers, Glenn. Beauty is in the eye of the beerholder.

It depends on what the error message actually is ... care to enlighten us all? Cheers, Glenn. Beauty is in the eye of the beerholder.

You also get the option box that xlhelp suggested when you pull the fill handle using the right-mouse button ( without having to change the options ). Cheers, Glenn. Beauty is in the eye of the beerholder.

If your week numbers are OK then some simple maths to adjust the year could be done by testing whether a) the month of the date is high ( like 12 ), and yet the week number is low ( say 1 ), then add 1 to the year b) the month of the date is low ( like 1 ), and yet the week number is high (...

OK, that's progress. Note that xlsm is also a valid filetype in Excel 2007 and Excel 2010. Cheers, Glenn. Beauty is in the eye of the beerholder.

You'll also get that message if you've saved a .txt file as .xls by the way. Can you open the file in Notepad? Cheers, Glenn. Beauty is in the eye of the beerholder.