I have a spreadsheet with 3 worksheets (tabs).
During the course of my work I quite often copy a worksheet by CTL +
left click and dragging.
Something has changed whereby now when I try to copy a worksheet by
this method I get a 'no entry' sign (circle with a slash through it).
I've checked all the tabs in ToolsOptions but cannot see anything
relevent.
I am using Excel2000.
can anyone tell me what's happening and how to correct it?
Many Thanks,
Dave Moore