how do I delete a worksheet from my workbook

D

DLee

I need to delete an empty worksheet from my workbook. Although I have tried
2 options:-

(a) edit menu, delete sheet
(b) select sheet, right click and then delete sheet

In both options the words "delete sheet" are dimmed and I am therefore
unable to delete the sheet.

It is a shared workbook
 
G

Gord Dibben

You cannot delete sheets from shared workbooks.

Un-share it first then delete the sheet.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shared Link is showing empty notebook 1
Delete 100 Hundred Unique Values From Word Document 0
selecting workbook/sheet 3
VBA for Dependents shortcut menu 0
Macro VBA coding, Copying content from one workbook to a new one 0
Resource Pool Project 2016 Standalone - how to remove reference to previously Shared, now deleted, files 0
Cell Toolbar Dilemma xl2013 13
How did I lose ability to add/edit comments in Excel 4

Top