Sheet get disabled by userform excel 2013

[VinayKumar15]

Hi all,

I have a code which activates a specific sheet and after activation a user form pops up.
Problem is when the user form pops up it disables the activated sheet which is not required.
Please suggest me how to achieve this. The code is -

Private Sub cmdOk_Click()
On Error GoTo ERROR:
    Dim strData As String
    strData = CBO_FORMAT.Text
    If strData = "STANDARD TEMPLATE" Then
        ThisWorkbook.iTempType = 0
        Excel.Application.Workbooks.Open (ThisWorkbook.sAppPath & "\StdTemplate.xltx")
        Set ThisWorkbook.myobject.xlAppSTD = Excel.Application
        ThisWorkbook.myobject.xlAppSTD.Visible = True
        ThisWorkbook.myobject.xlAppSTD.ActiveWorkbook.Activate
        ActiveWorkbook.Sheets("Report").Activate
        TemplateMEnu.AddTemplateMenus
        FrmUserFormat.Hide
        FrmReportSelect.Show vbModal

 

[NARAYANK991]

Hi ,

I am not sure what you mean , but try changing the keyword vbModal to vbModeless.

Narayan

 

[VinayKumar15]

Hi ,

I am not sure what you mean , but try changing the keyword vbModal to vbModeless.

Narayan

hi,

I have a workbook which contains multiple sheets. Sheet1 activates another sheet and then after activation a user form is loaded. At that point the sheet gets hidden and sheet1 is shown.

I have tried vbModeless and application.screenupdating = true (and false)
but they are not working.

Please help.

 

[NARAYANK991]

Hi ,

Please upload your complete workbook with the data , forms and code in it , and then explain the problem.

Narayan