Only allow 8 sheets open on workbook

[Yoepy]

I'm not even sure this question will make sense......but here goes.

I have a workbook that has many pages, which can make it unmanageable.

I have 5 sheets that need to remain open. The names on these sheets don't change.

But the others are based on a variety of variables. I currently close the sheets as follows (sorry for not using the code wrap)

Private Sub Worksheet_Deactivate()
Me.Visible = xlHidden 'Hide sheet

I use this to close the sheet I have been using after I leave it. (I use a VBA code to open it).

Should I just stop now.....

I want the five sheets + the last three that have been opened visible. If a forth sheet is opened then the oldest drops off being visible - the 5 remain visible.

If it helps the code to opens the sheets uses the sheet names, I could store those either dim or in a helper column

I really hope that makes sense. I'll just give up now.

Confused and confusing
Yoepy.

[davesexcel]

I suppose if you were using a code to hide and unhide sheets, you could place a value to that sheet beside a sheet list(helper column). it does sound confusing right now. Somehow, you would have to sort and replace the values on the go, which is no problem, just need to think on the logic some more.

Maybe supply a sample workbook, so we can work with your codes and worksheets