Worksheet tabs disappearing

D

donh

Hi Group,

I have an Excel 2000 workbook which I am getting reports of worksheets
missing.

The workbook has custom menus and the delete worksheet option is not
available and the right mouse tab menus are disabled.

Can a worksheet be deleted or dragged out of a workbook by error?

Any light on this would be great

Regards

Don
 
J

Jim Rech

Sometimes when you hide and unhide worksheets by macro the tabs of the newly
unhidden sheets are to the left of the first visible tab. People often
don't think to scroll the sheet tabs to the left to find them.

--
Jim
| Hi Group,
|
| I have an Excel 2000 workbook which I am getting reports of worksheets
| missing.
|
| The workbook has custom menus and the delete worksheet option is not
| available and the right mouse tab menus are disabled.
|
| Can a worksheet be deleted or dragged out of a workbook by error?
|
| Any light on this would be great
|
| Regards
|
| Don
 
D

donh

Sometimes when you hide and unhide worksheets by macro the tabs of the newly
unhidden sheets are to the left of the first visible tab.  People often
don't think to scroll the sheet tabs to the left to find them.

--

| Hi Group,
|
| I have an Excel 2000 workbook which I am getting reports of worksheets
| missing.
|
| The workbook has custom menus and the delete worksheet option is not
| available and the right mouse tab menus are disabled.
|
| Can a worksheet be deleted or dragged out of a workbook by error?
|
| Any light on this would be great
|
| Regards
|
| Don
Click to expand...

Hi Jim,

No they are gone. I've been into VBA and the sheet no longer exists!

Regards

Don
 
Top