Hi,
I want to write a code that let me hide some some sheets before save, then save the workbook and finaly unhide the sheets to continue working with workbook.
Someone
The idea is the workbook always presents the same face (a presentation sheet visible and the others hidden), no matter when or where it was saved.
I have solved this problem in the event of closing the workbook, but i can't figure it out how to make a simple SAVE and continue working.
The BeforeSave event doesn't work because it only saves at the end. So I need a kind of AfterSave event.
Anyone could help?
I want to write a code that let me hide some some sheets before save, then save the workbook and finaly unhide the sheets to continue working with workbook.
Someone
The idea is the workbook always presents the same face (a presentation sheet visible and the others hidden), no matter when or where it was saved.
I have solved this problem in the event of closing the workbook, but i can't figure it out how to make a simple SAVE and continue working.
The BeforeSave event doesn't work because it only saves at the end. So I need a kind of AfterSave event.
Anyone could help?