screen updating

  1. O

    Why does my Status Bar stop updating.

    I'm running a simulation with over 500,000 iterations. I've got screenupdating turned on on, statusBar display is on, and I've activated the status bar to print on the iteration number, but it prints out 6000+ and then stops. Could it be that the software is running faster than the screen can...
  2. S

    Excel VBA to unhide specific rows across multiple sheets

    I am looking to construct a VBA that unhides specific rows across different sheets in a workbook. I can write separate VBA for each sheet/row combination, but was wondering if I can put them all together instead? 3 sheets need the same rows unhidden that I already have code for: Sub Test()...
  3. S

    Screen Updating Difficulty - Any Ideas?

    Hello All! I am having a tricky time figuring out why I am still getting a screen update in my VBA when I really do not want it. It will just freak out my users and lead to more questions. I have a toggle box switch in VBA that moves, changes colours and executes a sub based on the position...
  4. U

    Using application.screenupdating in excel 2013 makes my unlocked cells in protected sheet - non editable

    I had an application in 2010 which was working fine. I recently have to migrate my application to 2013. There was lot of flickering occurred in 2013. So I have used application.screenupdating = false in beginning of my macro and set it back to TRUE during end of my macro. Though setting of...
  5. V

    Screen Updating - Unable to Disable Application.ScreenUpdating

    I am unable to disable the Application.screenUpdating propery. I've seen this issue referenced in various places but have yet to find a solution. Setting this value to false does not seem to do anything, as the value remains true in the watch window. Also, the screen still udpates...
  6. T

    Disable Mouse and Keyboard events while executing a macro

    I thought that setting ScreenUpdating and EnableEvents equal to false while executing code would disable all keyboard and mouse events while code is executing, but I was surprised to see that that was not the case. I have created a simple example that takes a few seconds to execute. While it...
  7. S

    Page Setup, Zoom, and Screen Updating issue.

    Hello everyone, I am looking for some insight as to whats going on with my code. I am learning a lot, but its my current issue that driving me bonkers. Im here to ask for some help. I have created a user form for Excel "print" formatting and would like to give the user an option that would...
  8. W

    Animation issue with screen updating?

    Hi All I’m very new to VBA and have run into a problem while adding some simple “animation” (moving images around the screen) to a system I’m developing. I have a sub which moves a specified image around the screen, I have tested this and it seems to work fine. However when I call it...
  9. F

    Worksheet Change - ScreenUpdating

    Hi, I`m using Worksheet_Change to put values in table. I set DisplayAlerts and ScreenUpdating to FALSE. Application.DisplayAlerts = False Application.ScreenUpdating = False If Target.Address = "$D$9" Then For g = 1 To rowdata_lr ...... next g End if...
  10. M

    Excel 2013, Thisworkbook.Activate does not ‘stick’ when Application.ScreenUpdating has been set to False

    Relates to Excel 2013 only- problem not found in pervious versions of Excel. ' Windows 8.1 V 6.3.9600 Build 9600 ' Excel 2013 (15.0.4551.1510) MSO(15.0.4551.1508)32-bit The simplest way for me to start explaining the problem I am having is the following four line procedure Test(). Sub...
  11. J

    Application.ScreenUpdating = True Doesn't Work

    <code>I have a strange problem, forever when I ran my code, the screen flashed. I found this line that turns off the flashing </code><code> </code><code>Application.ScreenUpdating = False That code worked perfectly, the screen no longer flashes, however, if I comment out that line and put in...
  12. O

    hiding macro copy/paste activity

    Hey guys, I have a macro which copies and paste from one sheet to another. Here is the code: Sub ENRL_Bolt() 'Transfer format from ENRL_Bolt to Survey Data Application.ScreenUpdating = False Sheets("SurveyData").Select 'Set column height width of the SurveyData sheet...
  13. M

    Screen update!!!

    Is there a way to turn screen updating on & off 2 make the macros run faster??? I've tried 2 make this work & it works OK until I try 2 enable the screen update again I get a debug error!!! Thanx 4 anyones help!!! God Bless!!!
  14. M

    Screen updating = false but still get message box

    Hi, When I run the following XML importing code I get a message box saying: "The specified XML source does not refer to a schema. Excel will create a schema based on the XML source data. [] In future do not show this message" I turned off the screen updating because I hoped it would then...
  15. B

    Screen Updating Not Working

    Hi, I've recently had a problem where whenever i opened a certain workbook it went into AutoRecover Saving and stayed like that until it crashed. As a workaround i added Application.AutoRecover.Enabled = False to Workbook_Open and Application.AutoRecover.Enabled = True to...
  16. E

    Changes to excel behaviour

    Hi, Not sure if this is something anyone could help me with... I have written a fairly large a complex workbook which runs a number of macros when it is opened, in order to set worksheet protection, scroll regions etc. I make extensive use of "Application.ScreenUpdating=False" to hide this...
  17. K

    Application.Screenupdating does not work

    I try to run this code with an Application.Screenupdating = False But visual basic still considers it true. Not really sure why. The screen shot should help.
  18. A

    Continuous Macro to rid screen blinking

    This may be a bit of a complicated message, but I currently have a macro that pulls in data via XML every 15 secs. I am using the screenupdating = false to stop the updating, but every time my macro runs, at the end, the screen will blink. I need help figuring out a way to get rid of that...
  19. S

    PowerPoint Screen Updating Nonsense

    I have created an add-in that will add disclaimers to all powerpoint presentations in a folder for a specific customer. All was working well until I decided to try to animate it. Before it would run in about 2-3 seconds per presentation, but as soon as the commented lines below are uncommented...
  20. O

    Detect user moving to another worksheet / screen updating

    In Excel 2002, I'm looking for a way to detect when a user has tried to move off a current sheet and if so trap that event to run code before the user is taken to that next sheet. I've tried using the deactivate event and it seems to display the next sheet before firing the deactivate event...

Some videos you may like

This Week's Hot Topics

Top