VBA trying to open data entry form but sheet with data needs to be hidden

[awesomeamz]

Hiya, I currently have 2 tabs within my document. The first sheet titled Dashboard has a macro button that opens a data entry form that is on sheet called Form Question Data.

My issue, is that I want to keep the Form Question Data sheet hidden but every time I run the macro to open the form, it won't open if I hide the sheet.

Can anyone help me with a simple code to run the macro whilst keeping this sheet hidden?

This is what it currently looks like:

Sub Macro3()
'
' Macro3 Macro
'

'
Sheets("Form Question Data").Select
Columns("A:X").Select
Range("X1").Activate
ActiveSheet.ShowDataForm
End Sub

 

[Micron]

AFAIK you cannot activate or select hidden sheets - and you probably don't need to. If you're trying to edit it with vba, then just do that.
e.g. sheets("mySheetName").range("A1") = "Hello"

 

[Fluff]

Hi & welcome to MrExcel.
As far as I know the in-built data form only works on the active sheet.
If you need to keep it hidden, then you will need to create your own userform.

 

[Micron]

I didn't realize this was about a data form. Seems that you can have your cake and eat it too. In the immediate window I executed the 2 lines in order and this is what I saw: