How do I make excels control impossible for people to use?

[tonywatsonhelp]

Hi Everyone.

Sub tewo()
Application.DisplayFullScreen = True
Application.DisplayFormulaBar = False
ActiveWindow.DisplayWorkbookTabs = False
ActiveWindow.DisplayHeadings = False
ActiveWindow.DisplayGridlines = False
End Sub

I use the above code to hide all excel tools etc to make the sheet look and be more of an input only sheet.
the page is also protected and this works great, but some staff insist on overriding the code with the escape Key.

Is there a more robust way to get excel to not have all its tools etc on show and lock it down so no user can override what its doing.

My ultimate result would be to have a screen that only has the sheet and no other controls except close and save.

any ideas would be appreciated.

Thanks

Tony

 

[dmt32]

Hi,
just a personal view but I would avoid trying to limit / remove workbook features to your users - if users don't like what you have done (clearly some don't if they are pressing the Esc key) then try & understand what it is about your application that bothers them & see if can work up a solution from there.

If you just take a blanket remove / block it all approach just be mindful users have the option to disable macros or just not use your workbook.

Dave