Cheers Ts Tom
The modification worked a dream for the standard and Formatting toolbars
but trying to hide either the "Worksheet Menu Bar", "Workbook tabs" or "Formula Bar"
resulted in;
Run-time error '2147467259 (80004005)':
Method 'visible' of object 'CommandBar' failed
Maybe I should detail my overall objectives as you might feel theres a better way of achieving them.
I have a simple single sheet workbook that I want users to simply enter data into but want to prevent them from making any changes to its layout format etc etc. and of course, without the hide "Worksheet Menu Bar" working they would simply right click and re-open it.
My one concern is that if indeed the hide "Worksheet Menu Bar", "Workbook tabs" had worked how could I then access the VB code to re-instate the toolbars, and make changes before re-hiding them for end user use.