Hi,

Apologies if I'm being stupid here, but if I disable the ribbon:

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)

and disable the right click menu functionality:

Application.CommandBars("Ply").Enabled = False

to stop my users from playing with things that I don't want them to, how do
I actually get at the code myself?

(Fortunately, i saved a copy before doing it!)

TIA


Dave

Maybe change False to True ?

Regards,
Per

"Risky Dave" skrev i meddelelsen
...
Hi,

Apologies if I'm being stupid here, but if I disable the ribbon:

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)

and disable the right click menu functionality:

Application.CommandBars("Ply").Enabled = False

to stop my users from playing with things that I don't want them to, how
do
I actually get at the code myself?

(Fortunately, i saved a copy before doing it!)

TIA


Dave

Sorry,

Not making myself clear.

If I enable the lines below in a workbook, save it, exit and then open it
again, the '07 ribbon is disabled and the right click menu is disabled. These
are the only two ways I know of (I'm new to this VBA stuff) of seeing the
code behind a sheet. Therefore I can't change the True/False switch.
Is there another way of getting at the code from the workbook or have I just
managed to completely lock myself out of my own work?

"Per Jessen" wrote:

Maybe change False to True ?

Regards,
Per

"Risky Dave" skrev i meddelelsen
...
Hi,

Apologies if I'm being stupid here, but if I disable the ribbon:

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)

and disable the right click menu functionality:

Application.CommandBars("Ply").Enabled = False

to stop my users from playing with things that I don't want them to, how
do
I actually get at the code myself?

(Fortunately, i saved a copy before doing it!)

TIA


Dave

Use Alt-F11, and select the appropriate project and the appropriate module.

--
__________________________________
HTH

Bob

"Risky Dave" wrote in message
...
Sorry,

Not making myself clear.

If I enable the lines below in a workbook, save it, exit and then open it
again, the '07 ribbon is disabled and the right click menu is disabled.
These
are the only two ways I know of (I'm new to this VBA stuff) of seeing the
code behind a sheet. Therefore I can't change the True/False switch.
Is there another way of getting at the code from the workbook or have I
just
managed to completely lock myself out of my own work?

"Per Jessen" wrote:

Maybe change False to True ?

Regards,
Per

"Risky Dave" skrev i meddelelsen
...
Hi,

Apologies if I'm being stupid here, but if I disable the ribbon:

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)

and disable the right click menu functionality:

Application.CommandBars("Ply").Enabled = False

to stop my users from playing with things that I don't want them to,
how
do
I actually get at the code myself?

(Fortunately, i saved a copy before doing it!)

TIA


Dave

Bob & Per,

Thanks for your responses (Per, also for the other one).

Now sorted :-)

"Bob Phillips" wrote:

Use Alt-F11, and select the appropriate project and the appropriate module.

--
__________________________________
HTH

Bob

"Risky Dave" wrote in message
...
Sorry,

Not making myself clear.

If I enable the lines below in a workbook, save it, exit and then open it
again, the '07 ribbon is disabled and the right click menu is disabled.
These
are the only two ways I know of (I'm new to this VBA stuff) of seeing the
code behind a sheet. Therefore I can't change the True/False switch.
Is there another way of getting at the code from the workbook or have I
just
managed to completely lock myself out of my own work?

"Per Jessen" wrote:

Maybe change False to True ?

Regards,
Per

"Risky Dave" skrev i meddelelsen
...
Hi,

Apologies if I'm being stupid here, but if I disable the ribbon:

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)

and disable the right click menu functionality:

Application.CommandBars("Ply").Enabled = False

to stop my users from playing with things that I don't want them to,
how
do
I actually get at the code myself?

(Fortunately, i saved a copy before doing it!)

TIA


Dave