Sum, Sum if or if???????

  • Thread starter Thread starter aly1cat
  • Start date Start date
A

aly1cat

Two things:

I inherited a spreadsheet and everytime I save or update a cell I get
message that reads "The macros in this project have been disabled
Please refer to online help etc to enable".
How can I get rid of this message, as as far as I know I not set up an
macros and there are none in the list after checking the macro list
(the spreadsheet I have enclosed for question 2 example does this i
you enter or change an amount)!


2. Can you help with a formula, basically I want excel to provide dat
if any particular figure is over a certain amount. see attache
example.

Thanks in advanc

Attachment filename: formula help.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=44001
 
Hi
probably there are some macros 'hidden' in the worksheet modules of
your workbook (they won't appear on your list). Try he following
- open your workbook
- right-click on the tab name of your sheet
- choose 'Code'
- delete everything in the appearing VBA editor

For your second question: I would try to use filtes for that (goto
'Data - Filter - Autofilter'). In the appearing dropdown list choose
custom and enter your conditions

Frank
P.S.: it would be better if you post your question in plain text
instead of attaching files
 
Back
Top