Search results

I discovered the following code (courtesy to Tom Urtis MVP) to Autohide the Taskbar but what I would like to do is store the state of Autohide in the Workbook_Open event - set it to autohide the taskbar - then restore it to the stored state in the Workbook_Close event. I tried debugging the...

There is lots of information on Emailing with Images, Signatures etc... on Ron De Bruin's website... http://www.rondebruin.nl/win/section1.htm Enjoy :)

Hi - Please can someone explain to me the subtle difference if any between... ThisWorkbook.Saved = True And ThisWorkbook.Save Many thanks in advance Jabba

Whey heh - problem solved... Options - Advanced - General (right down the bottom) - Scale Content for A4 or 8.5 x 11" paper sizes Make sure this is Unchecked... NOT Ticked... and ExportasFixedFormat then adheres correctly to the Print Preview Page Breaks... AND most importantly of course -...

Hi All, Print Preview displays correctly - ie. page breaks are where I want them and whichever printer I select the output works as expected. However when I use the following code the resultant PDF file is ignoring the page breaks despite the IgnorePrintAreas being set to False...

Hi All, I have a strange one... I am on a fully protected Sheet A... and I double click on any cell and I get the usual warning... "The cell or chart that you are trying to change is protected... etc..." and then I click "Ok"... THEN the strange behaviour kicks in... On clicking "Ok" a...

Hi Narayan... Sadly a complete typ-O on my part - and thankfully you spotted it... so I am now assuming the code is good to test - it was the concept of DoEvents / waiting for Calculation to finish / to then msgbox "Done" I was really getting at - so thankfully you spotted the typ-O anyway -...

Hi, So... I am trying to run some code to effect changes to the spreadsheet with Calculation State set to Manual, then switch it back to Automatic whilst retaining control still within the Macro - allow all the updates to take place and then putout a Msgbox "Done". The code is something like...

I was embedding the pic from Excel into Outlook using... With OutlookMsg .Subject = EmailTitle .HTMLBody = EmailMsg .To = ToMsg .CC = CCMsg .BCC = BCCMsg .Display End With and have now found a way of altering the size prior to...

Hi, I have managed to embed an image into Outlook email from Excel but would like to re-size it. Either by running a macro in Outlook if I have to... OR can I do it at the Excel end before I embed it into the Outlook message. The picture is a namedrange in Excel from which I create a .bmp...

I've uploaded an example to take a look at...

Not thought this all the way through but something like this... Create a unique list of all Categories and assign them 1 to n.... Then against each entry in your main list do a Vlookup on your list of categories to return the 1 to n bit. So your table columns now looks like this A B...

Hi All, Wondering if anyone can shed some light... I have a pivot table - I clear filters and set one filter - On a date filter I clear the (blank) pivot item - Then I Sort the date filter descending. But the list is not always in the correct order until I re-sort ascending and re-apply a...

One final thing... I had a look round the forum and couldn't find it... How to mark this as SOLVED ? Is this down to me or a forum moderator ? Thanks again

Hi Narayan, Yes it works many thanks... however the general process fails later in the Another sheet Worksheet Activate routine where I stipulate another cell reference in a similar manner... This suggests to me that the problem is down to not explicitly stating the sheet in the Range Select...

Just browsing on the forum to see where I can help... and you may have resolved this by now but this may help you... Right click a cell on the pivot table... select Pivot Table Options Make sure "Autofit column widths on update" is selected Exit out and then refresh your pivot table...

Hi SammyGirl I'm no guru and self-taught on VBA but like you I have date frustrations from time to time due to date internals of MS Excel being US format... I'm UK based. I haven't looked at your problem in detail... but off the bat... some things to check.. (i) Regional settings of PC -...

Hi All, All I am trying to do is essentially copy'n'paste data between sheets using VBA - something I have written code to do many times before... only this time I am getting an error on the line: Range("K2").Select with the error "Select method of Range class failed" The sub is...

RESOLVED - Found the answer... yeahhhhhh.... It boils down to Regional settings as originally suspected... In the Pivot Table... the date field... (mine was under Row Labels)... click the drop down arrow... click field settings... at the bottom of the form control that opens - click on...

Thanks SirJB7 for getting back to me so quickly... My spreadsheet is huge in volume 650,000 rows and many MB... so I went about creating a cut down version for testing and upload purposes as you suggested... Typically however I can no longer recreate the problem and all appears to be working...

Does anyone have a definitive code that works for UK Regional Date setting for filtering a pivot table between a date range where the dates are based on two cell values outside the pivot table (of course) ? I had the code working fine until I spotted that it wasn't working all the time and...

Hi Faseeh - thanks for getting back so quickly... Just this minute found the problem - and was coming back here to report accordingly and saw your response. I have different chart templates which I was invoking on sheet activation in the background dependent on a mode I had setup... the...

Ideas anyone ? I have various charts which I have set dynamic titles ie. based on a cell content The cell contents themselves contain formula to create a text narrative to form the chart title. The cell contents / formula vary based on a selection from a list box. Basically this works well...

Hi Narayan Thanks again but I was struggling to get the CSE working so started from scratch and worked my through it step by step and finally came up with this that gives me the result I need... by putting this into the C2, C9 and C17 etc...

Hi Narayan And thanks for getting back to me... and yes you have understood perfectly and yes you are right of course this works but only if I am putting the formula in a new column D. The problem is that strangely I need the result in column C above the elements it is summing... so I need...