Further Protection Question

[Risky Dave]

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

 

[Per Jessen]

Maybe change False to True ?

Regards,
Per

 

[Risky 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?

 

[Bob Phillips]

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

 

[Risky Dave]

Bob & Per,

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

Now sorted