Happy Friday!

I have a spreadsheet that someone else created with macros, conditional
formatting, etc. I'm trying to help revise it. Can you help with the
following questions:

1. How do I disable a macro?
2. When I try to edit a column that either have a macro or conditional
formatting, I get "run time error 13 type mismatch" - what does this mean?

The column that I am trying to revise has a validation list (say column B)
so if I type number in (column A), column B automatically defaults to "SST"
(a selection from the drop-down list). I need to have that default to
somehing else in the drop-down list say "Green" - how do I do that? I try to
find and replace or auto correct, it does not work, HELP!

Thanks in advance!

1. Set the security level higher (ToolsMacroSecurity)
2. Either the macro is expecting text and you enter a number or vice versa.

If the list is on the spreadsheet, right-click and look at the properties.
That should tell you what was used for the Input range.

"Rhonda" wrote:

Happy Friday!

I have a spreadsheet that someone else created with macros, conditional
formatting, etc. I'm trying to help revise it. Can you help with the
following questions:

1. How do I disable a macro?
2. When I try to edit a column that either have a macro or conditional
formatting, I get "run time error 13 type mismatch" - what does this mean?

The column that I am trying to revise has a validation list (say column B)
so if I type number in (column A), column B automatically defaults to "SST"
(a selection from the drop-down list). I need to have that default to
somehing else in the drop-down list say "Green" - how do I do that? I try to
find and replace or auto correct, it does not work, HELP!

Thanks in advance!