ToolBar Hidden via VBA, cannot unshare workbook

[surkdidat]

Morning

I have put the following code into the workbook to hide the toolbars etc, and shared the workbook. As its shared the Macros are disabled. I have saved the workbook, but when I have gone to click a button on my spreadsheet which sorts it, it bring up an error. How can I unshared the workbook, or force the spreadsheet to show me the tool bar please?

 Private Sub Workbook_Open()
 Application.ScreenUpdating = False
 Application.ExecuteExcel4Macro "Show.ToolBar(""Ribbon"",TRUE)"
 Application.DisplayFormulaBar = False
 Sheets("new multirate").Select
 Application.ScreenUpdating = True

 End Sub

 

[Craggs82]

open your non enabled workbook, then open a new workbook, Alt + f11 into the vbe (in the new workbook) and drop

Application.ExecuteExcel4Macro "Show.ToolBar(""Ribbon"",TRUE)"

into the immediate window.

should work.