code fails if graph is selected
Sorry... Not ActiveSheet. Should be ActiveCell.
Try this perhaps (I dont't tend to select things in my macros as you really
don't need to so this is just a guess)
Activesheet.Columns("B").select
Otherwise if you want to post your code we could probalby get rid of the
selects and get around this whole mess.
--
HTH...
Jim Thomlinson
"Scott" wrote:
So I guess this line which is before doesnt mean anything when the chart is
selected
Sheets("XYZ").Select
BTW the error message is
Run-time error "1004"
Method 'Columns' of object '_Global' failed
"Jim Thomlinson" wrote:
When the graph is selected there is no activesheet so
if activesheet is nothing then
msgbox "Sorry... Please de-select the graph before continuing..."
else
columns("B").Select
--
HTH...
Jim Thomlinson
"Scott" wrote:
This code fails if a graph on the same sheet is selected (clicking inside the
graph)
Columns("B:B").Select
If I unselect the graph (clicking ouside the graph) then code runs fine.
What can I put in the code to make sure the graphs are not selected?
|