Hi,
When i open workkbook i set the Application.DisplayFullScreen=true. when i close the workbook i set it back to false. But it works only if i close the workbook using the close (windows "x" btn). If i use the button in my worksheet to close, the workbook doesn't reset back to the fullscreen display mode.
I call application.activeworkbook.close on close click in my worksheet.
What should i do so that the screen display is reset back to the original?
Resetting the FormularBar and StatusBar also doesn't work.
Thanks
Veera
When i open workkbook i set the Application.DisplayFullScreen=true. when i close the workbook i set it back to false. But it works only if i close the workbook using the close (windows "x" btn). If i use the button in my worksheet to close, the workbook doesn't reset back to the fullscreen display mode.
I call application.activeworkbook.close on close click in my worksheet.
What should i do so that the screen display is reset back to the original?
Resetting the FormularBar and StatusBar also doesn't work.
Thanks
Veera