Results 1 to 4 of 4

Thread: Open invisible sheets in Excel

  1. Feb 21st, 2006, 01:39 AM #1
    HWijngaarD
    HWijngaarD is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2004
    Posts
    297

    Open invisible sheets in Excel

    Can it be done to open a sheet in Excel with macro which stays invisible?
    Reply With Quote Reply With Quote
  2. Feb 21st, 2006, 03:26 AM #2
    Zorban
    Zorban is offline
    New Member
    Join Date
    Feb 2006
    Posts
    7

    Talking Re: Open invisible sheets in Excel

    Hi,

    Application.ScreenUpdating = False
    Sheets(1).Visible = True
    'Do your actions here
    Sheets(1).Visible = False
    Application.ScreenUpdating = True

    This will stop the screen from updating while the sheet is made visible, meaning that it will not be displayed on the screen to a user. Once the work is done the sheet is made invisible again before turning on the ScreenUpdating.

    Hope this helps.

    Z
    Reply With Quote Reply With Quote
  3. Feb 21st, 2006, 02:42 PM #3
    zaza
    zaza is offline
    Frenzied Member zaza's Avatar
    Join Date
    Apr 2001
    Location
    Borneo Rainforest Habits: Scratching
    Posts
    1,486

    Re: Open invisible sheets in Excel

    You can still read to and write from sheets which are not visible. Try it.

    zaza
    Reply With Quote Reply With Quote
  4. Feb 21st, 2006, 06:15 PM #4
    Zorban
    Zorban is offline
    New Member
    Join Date
    Feb 2006
    Posts
    7

    Re: Open invisible sheets in Excel

    Can you really? I'm off to try it! Nice!

    MZ
    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