Cool Dashboards - Tricks

Dear RoyUK,

As I searched through the forum for help, I read this thread and found your fullscreen code in the sample file very helpful indeed. I wish to say a big 'thank you' for it. It really met a good deal of my needs.

When I use the code, however, I find that what still shows are the 3 buttons (minimize, restore and close) at the top right-hand corner. For what I am doing, I really need those 3 buttons disabled. I have an EXIT command button on the Main Menu sheet which SAVES & EXITS from the workbook that houses the Excel program that I am trying to design for my small family business.

In my further search, I found a code that disables the said 3 buttons, but I do not know how to incorporate it into your fullscreen code. I am totally new to vba/macros and would, please, appreciate your kind help. The code that I found is as follows:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = True
End Sub

Private Sub Workbook_WindowResize(ByVal Wn As Window)
Wn.WindowState = xlMaximized
EnableResize = False
End Sub

I should be grateful if you would kindly help me to incorporate this 3-buttons-disable code to your fullscreen code for my purpose, please.

Meanwhile, I hope I am not hijacking another forum member's thread. I was looking for a solution to my Excel 2007 problem, came across the thread and saw that the solution you provided met my needs, hence this post for your attention, please. I do not know how best to reach you concerning this. And if I have done anything wrong, I sincerely apologise.

Thank you in anticipation of your help.

Newqueen