Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-in causing 'GHOST' cells to be selected
I have an add-in which manipulates data on one of the xla's sheets
The problem is that if I'm in another workbook and I use the add-in some of the activebooks cells become selected(I may get three independent cells on the activesheet selected at the same time!) This looks really untidy and I think its down to the add-in Any ideas J |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-in causing 'GHOST' cells to be selected
Jason,
2 possibles (without seeing your code) Don't use select. This goes to the active window. Reference your cells by workbook and sheet name Workbooks("myxla").Sheets("Sheet1").Range("A1") (amend to fit your workbooks) You can do most code without selecting. Also speeds up processing. -- sb "jason" wrote in message om... I have an add-in which manipulates data on one of the xla's sheets The problem is that if I'm in another workbook and I use the add-in some of the activebooks cells become selected(I may get three independent cells on the activesheet selected at the same time!) This looks really untidy and I think its down to the add-in Any ideas J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple cells or columns are selected instead of selected cell or | Excel Discussion (Misc queries) | |||
zero value cells/blank cells causing error in AVERAGE? | Excel Worksheet Functions | |||
cells without values causing error message | Excel Discussion (Misc queries) | |||
Ghost numbers in blank cells | Excel Worksheet Functions | |||
Causing all calculated cells to refresh... | Excel Programming |