Code with Hidden Sheets

[Stormseed]

Can u help me with the code to hide / unhide entire worksheets - I need to unhide these 2 sheets before initiating my work and hide them again after I finish my work ! A macro wud be great !! Neverthless I know the basics of running and editing macros so that wud not be a problem :

EDIT - Split post - Smitty

 

[Smitty]

can u help me with the code to hide / unhide entire worksheets - I need to unhide these 2 sheets before initiating my work and hide them again after I finish my work ! A macro wud be great !! Neverthless I know the basics of running and editing macros so that wud not be a problem :

Why do they have to be hidden/unhidden? You can work with sheets (in most cases) visible or not. What are you trying to accomplish?

Smitty

 

[Stormseed]

Why do they have to be hidden/unhidden? You can work with sheets (in most cases) visible or not. What are you trying to accomplish?

Smitty

these sheets are loaded with lookup formulae like vlookup() and index()match()...I need to unhide these sheets in order to populate the values from another workbook and then the Reports are sent to the management wherein I need to hide these sheets (which infact look very shabby cuz of the scattered data all over) ! Its okay if u cant help...I can figure it out all myself !

 

[Smitty]

Formulas will calculate regardless of a sheet's visible status, unless you turned calculation off somewhere.

Might you be talking about links that lead to errors when a sent wb can't find the link?

If so, you can value an entire wb relatively easily.

Smitty

(As for helping, that's why everyone's here)...

 

[Stormseed]

Formulas will calculate regardless of a sheet's visible status, unless you turned calculation off somewhere.

Might you be talking about links that lead to errors when a sent wb can't find the link?

If so, you can value an entire wb relatively easily.

Smitty

(As for helping, that's why everyone's here)...

naaah....there is no linking issue here...I know wat has to be done wen the recipient receives some kinda linking error...moreover...in my case the formulae does not calculate or populate the values if the sheet is hidden...I need to unhide that particular sheet whose reference is present in the worksheet which has the formulae...only then the values are populated - now I dunno why is that happening

 

[Smitty]

OK,

It's pretty easy to tackle with ScreenUpdating and a WorkbookOpen event.

Although (it's really late) and I haven't run into this without UDF's or Volatile functions, and rarley at that.

I.E.

Private Sub Workbook_Open()
  With Application
    .ScreenUpdating  = False
      Sheets("Sheet1").Visible = True
    .Calculate
      Sheets("Sheet1").Visible = XlVeryHidden
    .ScreenUpdating = True
   End With
End Sub

That might do it for you.

Smitty

Note: written offhand and not tested in your situation, but feel free to send it to me.

 

[Stormseed]

just to add to your knowledge there is no sheet in the workbook where I have changed its property to "xlVeryHidden"