Show ribbon when switching workbooks

[dantray02]

hi,

I have a workbook that hides the ribbon, formula bar, etc on opening. What I would like to do is show all the hidden aspects when switching to another workbook, but when I go back to my workbook it hides everything again.

My code to hide is:

Please Login or Register  to view this content.

thanks,
dan

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. See rule #3. I have added code tags because you are still a new user. --6StringJazzer

[GC Excel]

You need to place this code in your workbooks event :

Please Login or Register  to view this content.

[Olly]

Use the Workbook Activate / Deactivate events:

Please Login or Register  to view this content.

Oh, and please put your code in CODE tags...

[dantray02]

Hi This works great thank you. however, I have the following code on a command button to close the work book and it now returns a "400" error when I click the ok box:

Sub excelclose()
If MsgBox("If you have made changes please ensure that a copy of this workbook has been saved in the client accounts folder for next year." & vbCr & vbCr & "Click OK to exit or cancel to return to the workbook and save.", vbOKCancel) = vbOK Then
ActiveWorkbook.Saved = True
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",true)"
ThisWorkbook.Close
Else
End If
End Sub

thanks again in advance.

[dantray02]

hi - sorry I did ask yesterday- how do I put the code in tags?

thanks

[dantray02]

thank you - i have read the rule about tags. thank you for highlighting it.

[dantray02]

hello - any ideas why this returns a "400" error message?

Please Login or Register  to view this content.