I have a workbbook which runs code in the 'ThisWorkbook'. At the present
time the programme is opening and closing without being able to do any
editing. I need to be to edit the code in the 'ThisWorkbook' routine to
prevent this.

Is there a way to prevent this code being run when opening. I have tried
the CRTL key and the Shift key but this doesn't work.

Any solutions would be greatly appreciated!

Mark

Mark
One way:
Open Excel.
Open a new blank file.
Click on Tools - Macro - Security.
Set the security to Medium.
Click OK.
Now open your problem file. You will get a box asking if you want to
Enable/Disable macros in that file. Click on Disable Macros. The file will
open and you can edit the macros as you wish. Note that you must save the
file and close the file and reopen the file with macros enabled to see what
your editing did. Post back if this doesn't work for you. HTH Otto
"Mark" wrote in message
...
I have a workbbook which runs code in the 'ThisWorkbook'. At the present
time the programme is opening and closing without being able to do any
editing. I need to be to edit the code in the 'ThisWorkbook' routine to
prevent this.

Is there a way to prevent this code being run when opening. I have tried
the CRTL key and the Shift key but this doesn't work.

Any solutions would be greatly appreciated!

Mark

Hold down the SHIFT key when you open the file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Mark" wrote in message
...
I have a workbbook which runs code in the 'ThisWorkbook'. At
the present
time the programme is opening and closing without being able to
do any
editing. I need to be to edit the code in the 'ThisWorkbook'
routine to
prevent this.

Is there a way to prevent this code being run when opening. I
have tried
the CRTL key and the Shift key but this doesn't work.

Any solutions would be greatly appreciated!

Mark

Thanks Otto,

Unfortunately, policy settings on this computer do not allow me to change
the security settings!

--
Mark


"Otto Moehrbach" wrote:

Mark
One way:
Open Excel.
Open a new blank file.
Click on Tools - Macro - Security.
Set the security to Medium.
Click OK.
Now open your problem file. You will get a box asking if you want to
Enable/Disable macros in that file. Click on Disable Macros. The file will
open and you can edit the macros as you wish. Note that you must save the
file and close the file and reopen the file with macros enabled to see what
your editing did. Post back if this doesn't work for you. HTH Otto
"Mark" wrote in message
...
I have a workbbook which runs code in the 'ThisWorkbook'. At the present
time the programme is opening and closing without being able to do any
editing. I need to be to edit the code in the 'ThisWorkbook' routine to
prevent this.

Is there a way to prevent this code being run when opening. I have tried
the CRTL key and the Shift key but this doesn't work.

Any solutions would be greatly appreciated!

Mark