awesomeamz
New Member
- Joined
- Aug 23, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
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
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