Hi,
Not sure what you want try positioning in the navigation sheet and save it
before closing

"Gazz_85" wrote:

how do i sort it ao that when a wookbook is opened it automatically shows the
sheet that is the navigation sheet.