deactivating menus

[Peter99]

I have a worksheet that I do not want the user to change by being able to access menu or sheet options

can anyone HELP

 

[Peter100]

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.

 

[Legacy 98055]

Hi
Maybe replace the Visible with
Enabled instead.
Can be used in combination as well.
I think, in this case, Enabled = False
will make 'em invisible anyway...

Private Sub Workbook_Activate()
Application.CommandBars("Standard").Enabled = False
End Sub

Private Sub Workbook_Deactivate()
Application.CommandBars("Standard").Enabled = True
End Sub

The ALT-F11 combination will bring
up your VBA editor without the need
for a bar.

I usually only hide the bars for viewing
space. Protection seems to work well
enough without hiding things.
But you know what you are doing and I
do not.

 

[Peter100]

Hi Tom
That worked great for the "Worksheet Menu Bar" but didn't work for the "Formula Bar" it does however solve my problem in this case.

I would like to have used protection to solve my needs but I am using Data-form to have the data entered and this seems to block creating new entries, unless you know a way round it.
This message was edited by Peter100 on 2002-04-24 05:44