Hi,
my right mouse button does not work in my Excel workbook! Can it be that is the workbook/-sheet is some kind of protected? How can I unprotect it?
Regards,
Jürgen
Hi,
my right mouse button does not work in my Excel workbook! Can it be that is the workbook/-sheet is some kind of protected? How can I unprotect it?
Regards,
Jürgen
is this in one workbook/sheet or all instances of Excel?
Edit: Check this post:
Hi,
only in one Workbook.
Ciao,
Jürgen
Hi Jurgen
If you didn't create the Workbook check to see if the code in the thread that I suggested exists and if so delete it.
Hi,
first there's s userform loaded automatically with the following code:
Private Sub UserForm_Initialize()
Call fncHasUserformCaption(False) ' UserForm ohne Titelleiste laden, damit es nicht verschoben werden kann
TextBox4.Text = Format(Now, "dd.mm.yyyy hh:mm") 'Anzeige von Datum und Zeit
ActiveWorkbook.Unprotect
'CommandBars("Worksheet Menu Bar").Enabled = True
Application.DisplayFullScreen = False
End Sub
and the following procedure is being called when the workbook is opened:
Sub aus()
Dim x As Integer
For i = 1 To Application.CommandBars.Count
If Application.CommandBars(i).Enabled = True And Application.CommandBars(i).Visible = True Then
x = x + 1
comands(x) = i
End If
On Error Resume Next
CommandBars(i).Enabled = False
CommandBars(i).Visible = False
Next
CommandBars(3).Enabled = True
CommandBars(3).Visible = True
'hide Status- and Formula Bar
Application.DisplayFormulaBar = False
Application.DisplayStatusBar = False
CommandBars("Worksheet Menu Bar").Enabled = True
Welcome.Show 'show Userform
End Sub
Display More
other code being called with the workbook's startup I couldn't find.
Jürgen
Don’t have an account yet? Register yourself now and be a part of our community!