View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default how can i stop the reviewing toolbar from automatically loading?

In your personal.xls file, insert the following in the workbook code area:

Private Sub Workbook_Open()
Application.CommandBars("Reviewing").Visible = False
End Sub

This will close the toolbar if it was accidentally left open.
--
Gary''s Student - gsnu200802


"bj62" wrote:

I don't use this function and would like to stop this happening. I believe
there is a macro that does this. Can anyone help?