View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Formula help please

Start excel (don't open that workbook).
Tools|Macro|Security|Security level tab|

Change it to Medium and you'll be prompted to allow macros each time you open a
workbook with macros.

Change it to low (microsoft doesn't recomment this!) and you'll never be
prompted, but you may be running macros that are not nice!

raju wrote:

dear sir

i am working in office excel 2003. when i load any macro it says "Macros in
this workbook are disabled because the security level is high,and the macros
have not been digitally signed or verified as safe. To run the macros. you
can either have them signed or change your security level. click help for
more information."

who i enable the workbook.

thanks.
raju
mumbai

"Stefi" wrote:

=IF(A1="New York",25,"")
Regards,
Stefi

shallowz ezt *rta:

i am a noob when it comes to excel formula's

this is what i want i hope it can be done

if in cell A1 i have the word New York i would like to have cell A7 show a
number like a 25

Cell A1
New York

As soon is that is typed in

Cell A7
25
Pops up

what is the formula i put in A7 so that can happen please


--

Dave Peterson