Results 1 to 6 of 6

Thread: Hiding Excel macro actions

  1. Feb 16th, 2006, 09:39 AM #1
    c19h28O2
    c19h28O2 is offline

    Thread Starter
    Member
    Join Date
    Feb 2006
    Posts
    48

    Hiding Excel macro actions

    Hi,

    Was wondering how to perform macro actions in the background, without the user seeing what happens on the screen, I know it can be done, just can't remember how!

    Thanks

    C19
    Reply With Quote Reply With Quote
  2. Feb 16th, 2006, 09:42 AM #2
    c19h28O2
    c19h28O2 is offline

    Thread Starter
    Member
    Join Date
    Feb 2006
    Posts
    48

    Re: Hiding Excel macro actions

    Apologies,

    Already solved my own questions

    Code:
    Application.ScreenUpdating = False 
  'code here 
Application.ScreenUpdating = True
    Reply With Quote Reply With Quote
  3. Feb 16th, 2006, 09:45 AM #3
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: Hiding Excel macro actions

    Also : Application.DisplayAlerts = false 'hides pop up questions/confirmations

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
  4. Feb 16th, 2006, 09:49 AM #4
    c19h28O2
    c19h28O2 is offline

    Thread Starter
    Member
    Join Date
    Feb 2006
    Posts
    48

    Re: Hiding Excel macro actions

    Hi,

    I know this is off the topic of the post but do you know how to open an access database from excel as if i explored to it and opened it?

    Thanks

    C19
    Reply With Quote Reply With Quote
  6. Feb 16th, 2006, 09:57 AM #5
    DKenny
    DKenny is offline
    Frenzied Member DKenny's Avatar
    Join Date
    Sep 2005
    Location
    on the good ship oblivion..
    Posts
    1,171

    Re: Hiding Excel macro actions

    Why do you need to open the database? Is your real intent to get data from the db?
    Declan

    Don't forget to mark your Thread as resolved.
    Take a moment to rate posts that you think are helpful
    Reply With Quote Reply With Quote
  7. Feb 16th, 2006, 10:02 AM #6
    c19h28O2
    c19h28O2 is offline

    Thread Starter
    Member
    Join Date
    Feb 2006
    Posts
    48

    Re: Hiding Excel macro actions

    No, I have a form that updates a database with excel data, but once the database is updated, i would like a message box to popup asking if the user would like to open the database.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width