View Single Post
  #4   Report Post  
tjtjjtjt
 
Posts: n/a
Default

Sounds like the file may be Protected and/or Shared.
Do yo usee the Word [Shared] after the Workbook name at the top of the Window?
If so, you should definitely get confirmation before trying to unshare it.
You'll have to Unshare it to Merge Cells or Delete Sheets. Again, get
confirmation that it is okay to do this, if you don't have the final say
yourself.
If it is okay to change it:
Tools | Share Workbook. Uncheck the box for allowing multiple users. If it
is greyed out, check Tools | Protection | Unprotect Shared Workbook. It may
ask you for a password. After it's Unprotected, then you can unshare it.

tj

"Mark F" wrote:

I'm working in a multiple worksheet workbook. I'm trying to label 12 columns
using the merge and center button but excel won't allow it. Also, deactivated
is the delete sheet option. This is a sheet built by another individual who I
can't reach to find out what he did to disable. This workbook is shared by
other workbooks (multi-company business plan financial statements).
HELP!