Search results

Hi I am sure this is a simple one for someone here. Why is this erroring and what is the solution. I was running just the pivottable2 and this was working fine. Now I add another 2 and I gain an error. Many thanks. Sub Dailydate() Sheets("Dashboard (Individual)").Select...

Details - TAB. Excel 2007 - the box stays the same - @ home Excel 2010 - the box becomes smaller - @ work. Any ideas.

Have tried. the Print Box shrinks on my work machine and not on my home machine. Any Ideas. Simple solution is to remove the print box on th secdond tab yet would be interested in why it is happening.

Thank you for your reply. Will redo all the boxes in active x buttons for the person. I did have the error in the spreadsheet I recieved. fix the error and it contiunued on the users machine so I think your idea will solve it. thank for your time once again. A++

Hi, A person designed this form and I have updated the code to simplify as it was there first attmept at design via VBA code. In both cases the person has a problem with the Print Box on the details TAB becoming shorter. I have tested on excel 2007 at home and it works. with excel 2010 at...

Hi Luke, Tried it again as a module with an update button. using offset 0,2 and it has worked. I do not understand. Will need to do more testing. you are welcome to advise if required Many Thanks. Ian.

Hi Luke, Thanks. It is close. Can you see if you can get this working. I have tried. Please do not put Off set 0,2 in as it loops on the display email !!! lol

Here is my program @ present. The Email part of the Program is called when required Sub Mail_with_outlook2 Private Sub Worksheet_Calculate() Dim FormulaRange As Range Dim NotSentMsg As String Dim MyMsg As String Dim SentMsg As String Dim MyLimit As Double NotSentMsg = "Not Sent"...

Hi, I have Cells A1 to A8 as an example. I send emails to people and the cell changes from Email Await to Email Sent. How can I place the Date the email was sent into B1 to A8 each time I open the spreadsheet. I have auto email sent and my VBA program changes the Cell range in A. I already...

Hi All, Unable to find any examples of this on the internet. Was want to make live easy for day activities for many people in the company I have an email that I send out with the subject line : Request Number nnnnnn (Group Access - Granted) We send hundreds of these each week ...

Hi JB7, a) Yes Simple way. Open or Open, Update and Close c) You have given me the idea. When Column : Email Sent C changes then place todays date in a new column. Then in the new column would be if todays date then count giving me the mails sent for today 0 or X or another way would be to...

a) I was thinking a schedule to run .vbs to open excel and run the macros else another .vbs to just open in thisworksheet. b) completed.! c) do you have any ideas on this one.?

Hi Sir JB7, a) Yes - Will open, update and close.... except if a person needs to add data. b) Yes - I have done this at it will automatically update when sending the emails out including my cc copy. c) Yes - A summary stating you have sent 0 emails today or you have sent 2 emails today.

Hi, I was thinking. when the spredsheet runs each day (In the morning) if any changes (from Not Sent to Sent) in column C then an email would be sent to myself to confirm you have sent (e.g.) 2 emails today or you have sent 0 emails today as it would run once each day via a windows schedule and...

Here is the file !!!! Thanks Bob. ANyone is welcome if they have an answer.

Hi JB. I have finished my Spreadsheet. Can you look at this as I would like to : a) If no changes when opened via a schedule will send an email to myself confirming no changes for today b) Will open update, send emails and close sending emails and an email to myself stating how many emails...

Hi SirJB. Has beena while. I have a few ideas about this one and just wanted to ask to see if any one selse had any ideas. Thanks for the link. will check this out and post when I am my sheet operation. Do like the like POST PDF which is triggering more ideas. thanks for the advise and time as...

send automated emails to contract owners ( Column "Q") as soon as the contract is due ( Column "O") based on the review date(Column "P") CELL O Notice Period CELL P Review Contract by CELL Q Contract Owner CELL O 90 CELL P 03-Jul-14 CELL Q purchasing@domain.com If Today is = or > than P2...

Narayank991 - you are a STAR !!! - it is the finishing touch on my Automated Multi Dashboard. The dashboard is completed....... wooohooo !!!! Many thanks... Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) Dim pt As PivotTable With Range("A83:ac342").Interior...

Hi Narayan, I understand. your coding is very close to the solution i require. If I have 4 pivot tables it is colouring the background grey which is what I require (around 4 pivot tables) yet also colouring the three tables I did not update grey inside. the one table I did change goes white. can...

Sorry, the background around the pivot table is grey and the pivot table is white. Conditional formatting does not remain the grey background when the pivot tabel data is refreshed and the item length shortens. the background shows white not grey. Private Sub Worksheet_PivotTableUpdate(ByVal...

conditinal formatting - format only cells that contain. - cell value equals ="" Format - Grey colour selected. try and move a pivot table up and down in columns and you will see that the formatting does not work. I am looking for a solution to keep the grey background surrounding the pivot...

It is around the pivot table I would like to keep the background grey. the pivot table is white. If you use conditional formating in excel 2007-2010 then it does not keep the conditional formatting when the pivot table move less in rows and then more. it leave the formatting around the pivot...

Hi All, conditional formatting does not work around a pivot table if asking for all grey after the pivot tabel has more then less columns except for the left column under the pivot table when changed using ="" and the colur grey. I was attempting to write a VBA program for everytime a...

The VBA Program above is linked via VBA Front Screen with a resfresh button for the values and an close button. I do a restart by closing the application and loading the application again.