See attached for sample solution. It's quick and dirty but gets the job done.
To manually calculate, use the Application.Calculate command. To display the warning message, you need to hook the Worksheet_Change event. You should have a public boolean flag declared at the module level that tracks whether the worksheet has been calculated so that both the method that calculates the page and the method that displays the warning can access and change it. Hope this helps. On Sep 3, 3:39 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Hi > > I’m trying to make a simple routine in excel VB so, when a command > button is pressed, the whole workbook is calculated (I have automatic > calculation set to manual). I also want to display a warning message > to the end user when input data is changed but the “calculate” button > has not been pressed. > > Can anyone point me in the right direction? > > Any help would be very much appreciated. --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
