Hiding sheet from Access VBA.

[kashif.special2005]

Hi,

I am trying to apply xlveryhidden from Access but it is not working properly, it is hiding sheets but bot veryhidden means it is showing those sheets in unhide window.

Code

my_excel.Sheets("BSI Feedback Data DB").Visible = xlVeryHidden
my_excel.Sheets("Calculation Sheet").Visible = xlVeryHidden

Please help.

Thanks
Kashif

 

[Trevor G]

This works for me, what else is your code doing?

Sub hideShet()
Dim ws As Excel.Application
Set ws = CreateObject("Excel.Application")
With ws
    .Workbooks.Add
    .Sheets("sheet2").Visible = xlVeryHidden
    .Sheets("Sheet3").Visible = xlVeryHidden
    .Visible = True
    
End With

End Sub

 

[kashif.special2005]

Hi Trevor,

Thanks for reply

I have tried severl options for that I found the right option and that is
xlsheetveryhidden

below code is working fine

my_excel.Sheets("BSI Feedback Data DB").Visible = xlSheetVeryHidden

Thanks
Kashif.