Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Deleting a conditional format
I have the following CF in every cell of two separate worksheets in one
workbook. I am using Excel 2000 with Win 98SE =ROW()=ROW(INDIRECT(CELL("address"))) When I try to delete it, it appears I am successful until I select a cell then the CF is again active in every cell. The main problem is that I cannot copy/paste or insert new rows to insert copied data. I thought I had downloaded Chip Pearsons symbolize add in to highlight the active cell, this add in has been removed, however, some workbooks continue to flash an error that this addin cannot be found when I execute them. Can anyone suggest how I can get rid of this macro/addin whatever????? Thanks, Mark |
#2
|
|||
|
|||
Mark,
Sounds like you have some event code behind the sheet. Right-click the sheet name tab, and select View Code. Check if the popup window shows some code that might look suspect. -- HTH RP (remove nothere from the email address if mailing direct) "Mark Strohmeyer" wrote in message ... I have the following CF in every cell of two separate worksheets in one workbook. I am using Excel 2000 with Win 98SE =ROW()=ROW(INDIRECT(CELL("address"))) When I try to delete it, it appears I am successful until I select a cell then the CF is again active in every cell. The main problem is that I cannot copy/paste or insert new rows to insert copied data. I thought I had downloaded Chip Pearsons symbolize add in to highlight the active cell, this add in has been removed, however, some workbooks continue to flash an error that this addin cannot be found when I execute them. Can anyone suggest how I can get rid of this macro/addin whatever????? Thanks, Mark |
#3
|
|||
|
|||
Hi Mark,
Try selecting all cells (Ctrl+A) then under Conditional Formatting delete all three formats Pasting a cell with formatting will copy it's formatting which includes number formatting, borders, and conditional formatting. Likewise can remove each of those formatting. For you second problem of deactivating an addin, did you try tools, addin and deactivate (uncheck) the addin. That way you can bring it up again. To completely get rid of it delete the actual addin from the directory shown there, then try to activate the addin, it should go away when not found where it is supposed to be. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Mark Strohmeyer" wrote in message ... I have the following CF in every cell of two separate worksheets in one workbook. I am using Excel 2000 with Win 98SE =ROW()=ROW(INDIRECT(CELL("address"))) When I try to delete it, it appears I am successful until I select a cell then the CF is again active in every cell. The main problem is that I cannot copy/paste or insert new rows to insert copied data. I thought I had downloaded Chip Pearsons symbolize add in to highlight the active cell, this add in has been removed, however, some workbooks continue to flash an error that this addin cannot be found when I execute them. Can anyone suggest how I can get rid of this macro/addin whatever????? Thanks, Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional format of data tables in charts | Charts and Charting in Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
deleting a conditional format | Excel Discussion (Misc queries) | |||
make a conditional format the default | Excel Discussion (Misc queries) | |||
Conditional format | Excel Discussion (Misc queries) |