How do I set default a worksheet on open *without* VBA - Excel 2007 ??

[insanity82007]

I'm wondering how to set an Excel Worksheet to open on a default sheet without using VBA.

The reason why I don't want to use VBA to set a default worksheet through the workbook open event is because the worksheet I want to open with will display that macros are disabled for the user and will have a guide to enable them. If macros are disabled then obviously the workbook open event won't have worked and this default sheet will be displayed. If macros are enabled then the workbook open code will run and the code will display a different worksheet and hide the default sheet.

How do I set a default sheet/workbook structure so that every time a user opens the workbook it will be displayed this way, regardless of whether or not the user saved the workbook with a different sheet dislpayed previously?

 

[JLGWhiz]

I'm wondering how to set an Excel Worksheet to open on a default sheet without using VBA.

The reason why I don't want to use VBA to set a default worksheet through the workbook open event is because the worksheet I want to open with will display that macros are disabled for the user and will have a guide to enable them. If macros are disabled then obviously the workbook open event won't have worked and this default sheet will be displayed. If macros are enabled then the workbook open code will run and the code will display a different worksheet and hide the default sheet.

How do I set a default sheet/workbook structure so that every time a user opens the workbook it will be displayed this way, regardless of whether or not the user saved the workbook with a different sheet dislpayed previously?

The only way that comes to mind is to use the Workbooks_BeforeClose event to make sure that sheet is the visible and active sheet when the workbook is last saved.

 

[shg]

If you search the board (and elsewhere) for force user to enable macros, that's commonly part of the code.

 

[insanity82007]

The only way that comes to mind is to use the Workbooks_BeforeClose event to make sure that sheet is the visible and active sheet when the workbook is last saved.

The issue with that is that it forces a save before closing and the user may not want to save

 

[insanity82007]

If you search the board (and elsewhere) for force user to enable macros, that's commonly part of the code.

These all come back to the same problem: forcing the user to save before closing

 

[insanity82007]

Is there any way of saving a workbook structure on close but not the data?

 

[shg]

The issue with that is that it forces a save before closing

It doesn't force a save before close; when the user initiates a save, it hides all but one sheet, then restores the view after the save. The user can close without saving.

 

[insanity82007]

It doesn't force a save before close; when the user initiates a save, it hides all but one sheet, then restores the view after the save. The user can close without saving.

The code I found forced the user to save. What you've suggested is a great approach and I'll implement this. Cheers

 

[shg]

You're welcome. Holler back if you have problems.