+ Reply to Thread
Results 1 to 5 of 5

Can't Insert/Delete Sheets in a Workbook

  1. #1
    Registered User
    Join Date
    02-20-2011
    Location
    Queensland, Australia
    MS-Off Ver
    Office 365
    Posts
    71

    Can't Insert/Delete Sheets in a Workbook

    Thanks for all the help.

    mgs
    Last edited by mgs; 06-26-2015 at 12:42 AM.

  2. #2
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: Can't Insert/Delete Sheets in a Workbook

    At the top of Excel, where you see the tabs for Home, Insert, Page Layout etc...

    Look for one that says Review
    The find an icon with a lock on it that says Unprotect Workbook.
    Click that - enter password if it prompts for it.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Can't Insert/Delete Sheets in a Workbook

    Do you get any message window that opens when you 1st try and openthe workbook?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    02-20-2011
    Location
    Queensland, Australia
    MS-Off Ver
    Office 365
    Posts
    71

    Re: Can't Insert/Delete Sheets in a Workbook

    "Excellent, it works!"

    Thanks,
    mgs

  5. #5
    Registered User
    Join Date
    02-20-2011
    Location
    Queensland, Australia
    MS-Off Ver
    Office 365
    Posts
    71

    Re: Can't Insert/Delete Sheets in a Workbook

    Quote Originally Posted by quekbc View Post
    At the top of Excel, where you see the tabs for Home, Insert, Page Layout etc...

    Look for one that says Review
    The find an icon with a lock on it that says Unprotect Workbook.
    Click that - enter password if it prompts for it.
    "Excellent, it works!"

    Thanks,
    mgs
    Last edited by mgs; 06-26-2015 at 12:33 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Delete sheets and create a new workbook in Shared Workbook.
    By honger in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-02-2014, 01:35 PM
  2. Macro to insert/delete rows in multiple sheets
    By lorigies in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-18-2014, 11:15 AM
  3. Replies: 1
    Last Post: 10-04-2013, 04:21 AM
  4. [SOLVED] Insert/delete row on 2 sheets in the same location by short key
    By nokondi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2013, 06:49 PM
  5. Code to delete sheets and rename sheets in a protected workbook?
    By leaning in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-07-2011, 03:02 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1