Access sheet While Application.Visible = False

[ilya2004]

Hello,

I have a spreadsheet that auto-loads a userform and runs an

application.visible = false

command.

The issue is that I need the userform to interact with the sheet, but once I have hidden the worksheet I get a "subscript out of range" error.

Is there a way to allow it to do so without unhiding the application?

-Ilya

 

[ZVI]

Hi Ilya,
Should work, try:

Private Sub UserForm_Initialize()
  Application.Visible = False
End Sub

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
  Application.Visible = True
End Sub

Private Sub CommandButton1_Click()
  With ThisWorkbook.Sheets(1)
    .Range("A1:D3").Value = Now
    MsgBox .Range("A1").Value
  End With
End Sub

Regards