software

set the macro too high now it will not let me input any data into any
worksheet new or old and can not get into options.

can anyone help me change the settings so that i may use the excel

I have office 2003 professional
thank you for your help.

Diane
Setting the macro security to quot;Highquot; will not prevent data entry. Maybe
you protected the sheet or sheets. That will do what you say. Click on
Tools - Protection - Unprotect sheet and see if that helps. Please post
back with the results. HTH Otto
quot;Dianequot; gt; wrote in message
...
gt; set the macro too high now it will not let me input any data into any
gt; worksheet new or old and can not get into options.
gt;
gt; can anyone help me change the settings so that i may use the excel
gt;
gt; I have office 2003 professional
gt; thank you for your help.
Otto,
thank you for your response. I did not set the protection on. After I set
the macro security to extreme high. all the items in the pull down of tools
are now unaccessible and i can not change back the security setting on the
macro. any suggestions on what may be causing this.
diane

quot;Otto Moehrbachquot; wrote:

gt; Diane
gt; Setting the macro security to quot;Highquot; will not prevent data entry. Maybe
gt; you protected the sheet or sheets. That will do what you say. Click on
gt; Tools - Protection - Unprotect sheet and see if that helps. Please post
gt; back with the results. HTH Otto
gt; quot;Dianequot; gt; wrote in message
gt; ...
gt; gt; set the macro too high now it will not let me input any data into any
gt; gt; worksheet new or old and can not get into options.
gt; gt;
gt; gt; can anyone help me change the settings so that i may use the excel
gt; gt;
gt; gt; I have office 2003 professional
gt; gt; thank you for your help.
gt;
gt;
gt;

The macro security setting does not effect your access to the sheet and data
entry or menu items access. Exactly what did you do when you set the
quot;Macroquot; security to extreme high. The security setting has only Low,
Medium, and High. Give me a step-by-step of what you did. HTH Otto
quot;Dianequot; gt; wrote in message
...
gt; Otto,
gt; thank you for your response. I did not set the protection on. After I
gt; set
gt; the macro security to extreme high. all the items in the pull down of
gt; tools
gt; are now unaccessible and i can not change back the security setting on the
gt; macro. any suggestions on what may be causing this.
gt; diane
gt;
gt; quot;Otto Moehrbachquot; wrote:
gt;
gt;gt; Diane
gt;gt; Setting the macro security to quot;Highquot; will not prevent data entry.
gt;gt; Maybe
gt;gt; you protected the sheet or sheets. That will do what you say. Click on
gt;gt; Tools - Protection - Unprotect sheet and see if that helps. Please post
gt;gt; back with the results. HTH Otto
gt;gt; quot;Dianequot; gt; wrote in message
gt;gt; ...
gt;gt; gt; set the macro too high now it will not let me input any data into any
gt;gt; gt; worksheet new or old and can not get into options.
gt;gt; gt;
gt;gt; gt; can anyone help me change the settings so that i may use the excel
gt;gt; gt;
gt;gt; gt; I have office 2003 professional
gt;gt; gt; thank you for your help.
gt;gt;
gt;gt;
gt;gt;
Otto

Info only.

Excel 2003 has a 4th level which is quot;Very Highquot;

Diane

With Excel open go to Helpgt;Aboutgt;Disabled Items.

Anything there you could re-enable?

Also, as Otto asks, give a step by step of what you think you did.Gord Dibben MS Excel MVP

On Tue, 4 Apr 2006 16:26:40 -0400, quot;Otto Moehrbachquot; gt;
wrote:

gt;The macro security setting does not effect your access to the sheet and data
gt;entry or menu items access. Exactly what did you do when you set the
gt;quot;Macroquot; security to extreme high. The security setting has only Low,
gt;Medium, and High. Give me a step-by-step of what you did. HTH Otto
gt;quot;Dianequot; gt; wrote in message
...
gt;gt; Otto,
gt;gt; thank you for your response. I did not set the protection on. After I
gt;gt; set
gt;gt; the macro security to extreme high. all the items in the pull down of
gt;gt; tools
gt;gt; are now unaccessible and i can not change back the security setting on the
gt;gt; macro. any suggestions on what may be causing this.
gt;gt; diane
gt;gt;
gt;gt; quot;Otto Moehrbachquot; wrote:
gt;gt;
gt;gt;gt; Diane
gt;gt;gt; Setting the macro security to quot;Highquot; will not prevent data entry.
gt;gt;gt; Maybe
gt;gt;gt; you protected the sheet or sheets. That will do what you say. Click on
gt;gt;gt; Tools - Protection - Unprotect sheet and see if that helps. Please post
gt;gt;gt; back with the results. HTH Otto
gt;gt;gt; quot;Dianequot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt; gt; set the macro too high now it will not let me input any data into any
gt;gt;gt; gt; worksheet new or old and can not get into options.
gt;gt;gt; gt;
gt;gt;gt; gt; can anyone help me change the settings so that i may use the excel
gt;gt;gt; gt;
gt;gt;gt; gt; I have office 2003 professional
gt;gt;gt; gt; thank you for your help.
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;Gord
Thanks for that. I didn't know that. Otto
quot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote in message
...
gt; Otto
gt;
gt; Info only.
gt;
gt; Excel 2003 has a 4th level which is quot;Very Highquot;
gt;
gt; Diane
gt;
gt; With Excel open go to Helpgt;Aboutgt;Disabled Items.
gt;
gt; Anything there you could re-enable?
gt;
gt; Also, as Otto asks, give a step by step of what you think you did.
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Tue, 4 Apr 2006 16:26:40 -0400, quot;Otto Moehrbachquot;
gt; gt;
gt; wrote:
gt;
gt;gt;The macro security setting does not effect your access to the sheet and
gt;gt;data
gt;gt;entry or menu items access. Exactly what did you do when you set the
gt;gt;quot;Macroquot; security to extreme high. The security setting has only Low,
gt;gt;Medium, and High. Give me a step-by-step of what you did. HTH Otto
gt;gt;quot;Dianequot; gt; wrote in message
...
gt;gt;gt; Otto,
gt;gt;gt; thank you for your response. I did not set the protection on. After I
gt;gt;gt; set
gt;gt;gt; the macro security to extreme high. all the items in the pull down of
gt;gt;gt; tools
gt;gt;gt; are now unaccessible and i can not change back the security setting on
gt;gt;gt; the
gt;gt;gt; macro. any suggestions on what may be causing this.
gt;gt;gt; diane
gt;gt;gt;
gt;gt;gt; quot;Otto Moehrbachquot; wrote:
gt;gt;gt;
gt;gt;gt;gt; Diane
gt;gt;gt;gt; Setting the macro security to quot;Highquot; will not prevent data entry.
gt;gt;gt;gt; Maybe
gt;gt;gt;gt; you protected the sheet or sheets. That will do what you say. Click
gt;gt;gt;gt; on
gt;gt;gt;gt; Tools - Protection - Unprotect sheet and see if that helps. Please
gt;gt;gt;gt; post
gt;gt;gt;gt; back with the results. HTH Otto
gt;gt;gt;gt; quot;Dianequot; gt; wrote in message
gt;gt;gt;gt; ...
gt;gt;gt;gt; gt; set the macro too high now it will not let me input any data into any
gt;gt;gt;gt; gt; worksheet new or old and can not get into options.
gt;gt;gt;gt; gt;
gt;gt;gt;gt; gt; can anyone help me change the settings so that i may use the excel
gt;gt;gt;gt; gt;
gt;gt;gt;gt; gt; I have office 2003 professional
gt;gt;gt;gt; gt; thank you for your help.
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;
gt;