i want to use xlveryhideen

[bhandari]

i have 2 shees which i need to use "xlveryhidden" Macro There is a issue with using it

1st sheet=input1
2nd sheet input2

This sheet are linked to other sheets with macro,if two sheets are visible then macro is running properly

Sub Boom()
Sheets("SheetName").Visible = xlVeryHidden
Sheets("SheetName").Visible = False
End Sub

My intention to use above code but its not working if both sheet are "xlveryhidden" before running my linked Macro

 

[Logit]

.
First UNHIDE the sheets ... then run your macro ... then HIDE the sheets again.

 

[santoshloka]

.
First UNHIDE the sheets ... then run your macro ... then HIDE the sheets again.

Can we do with macro?

 

[Logit]

.
'In the ThisWorkbook module :

Private Sub Workbook_Open()
Sheets("Sheet2").Visible = xlVeryHidden
Sheets("Sheet3").Visible = xlVeryHidden
End Sub

'In a Routine Module "

Sub Boom()
Sheets("Sheet2").Visible = xlSheetVisible
Sheets("Sheet3").Visible = xlSheetVisible


'Your macro code goes here


Sheets("Sheet2").Visible = xlVeryHidden
Sheets("Sheet3").Visible = xlVeryHidden


End Sub