VBA

Hi,

I have been working on a workbook that contains Macro for hiding columns with Modano active. 

I understand that Modano has password protection to prevent unwanted changes in the formula and formats but this has caused my code to break every time I re-open the workbook.

Is there any way to get around this without releasing the workbook?

Attached is a screenshot of the error that I got every time I run the code right after I open the workbook. 

Thanks

Hi guys

Is it possible to hide sheets with VBA code in modular workbook?

I tried but it throws some error and the code is working with other files.Could you clarify?

See code below:

Sub SwitchToUserMode()
    Dim wks As Worksheet
    For Each wks In ActiveWorkbook.Sheets
        If wks Is ActiveSheet Or InStr(1, wks.Name, "User") > 0 Then
            wks.Visible = xlSheetVisible
        Else
            wks.Visible = xlSheetHidden
        End If
    Next wks
End Sub

Are there any tricks to using VBA to manipulate content within module components in modular workbooks?