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...

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

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, 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...

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...

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...

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...

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...

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, Getting all confused with MATCH, INDEX, SUMIFS, COUNTIFS, etc... A B C 1 Ref Sub-Ref Total 2 P001 00 16 <---- Looking to calculate this figure 3 P001 01 2 4 P001 02 4 5 P001 03 2 …based on the sum of these figures 6 P001 04 1 / 7 P001 05 5 / 8 P001 06 2 / 9 P002 00...

I've checked out Chandoo's extensive summary on Hyperlinks but still getting myself in a pickle... !! Found this out there out there on the net... courtesy of someone called Webtest Sub HyperlinkMoveTest() Dim aSheet As Worksheet 'Sheet Handle Dim hLink As Hyperlink 'Hyperlink Handle...

Hi - Any assistance gratefully received... I am trying to toggle between worksheets whilst maintaining the relative scroll position. The idea being that if I scroll down to row Row 500 in Sheet A... and then click the tab to move to Sheet B... that when Sheet B Activates it sets the scroll...

Hi All, Sadly got myself in a bit of a mess... I am creating a dashboard and in the process I have created numerous sheets calling a finite number of Pivot Tables. The Pivot Tables are very large and I think that in my excitement I have created at least a couple of Pivot Tables that are no...