Results 1 to 3 of 3

Thread: Hide my actions

  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hide my actions

    I've got a spreadsheet I send out to all my users which they use to keep track of thier phone calls. At the end of the day, I have 10 spreadsheets, saved in the format ini-yyyy-dd-mm.xls.

    At the end of the month, i've got around 200 such spreadsheets.

    Working 20 or so at a time, I've got another spreadsheet which prompts me for initials, and consecutively opens each spreadsheet in a given directory with those initials. It then pulls data (copy) from the sheet and pastes it into my 'Admin' database. (This is to get a compilation of a users statistics)

    My question is, although i've got the thing flipping from page to page in code, is there any way to display a userform in place of the dizzying screen changes that take place when going back and forth instantaneously from spreadsheet to spreadsheet?

    Any help is greatly appreciated!
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide my actions

    Found it.. [img]/forums/images/smilies/smile.gif[/img]

    Application.ScreenUpdating = False

    Still playing with the userform tho.. [img]/forums/images/smilies/smile.gif[/img]
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide my actions

    Drk,

    Although I have not experienced any problems it is Good Programming Practice to swith ScreenUpdating back to True at the end of your procedure.

Posting Permissions

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