Userform ativo, utilizando outras arquivos do Excel. RRS feed

  • Question

  • Hello guys!

    I'm trying to make a userform work that is in a worksheet, but I want to use and manipulate other excel worksheets. I know that by including a zero in front of the code it lets you manipulate other spreadsheets, as below:

    Private Sub CommandButton1_Click()
    UserForm1.Show 0
    End Sub

    Private Sub Worksheet_Activate()
        With ActiveWindow
            .DisplayHeadings = False
            .DisplayWorkbookTabs = False
            .DisplayHorizontalScrollBar = False
            .DisplayVerticalScrollBar = False
        End With
        Application.DisplayFormulaBar = False
    End Sub

    But the idea is to hide the commands from the folder that contains this form and keep them available in the other files that you open from excel.

    Does anyone know if it is possible?


    Sunday, January 21, 2018 10:46 PM


  • You ask your question in the Small Basic language forum.

    You can better ask this in an Excel-forum.

    Jan [ WhTurner ] The Netherlands

    • Marked as answer by Cdilenes Monday, January 22, 2018 9:54 PM
    Monday, January 22, 2018 10:00 AM

All replies