Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

In Excel Cannot Add Sheets


  • Please log in to reply

#1
statman45

statman45

    New Member

  • Member
  • Pip
  • 3 posts
I cannot add new sheets within a worksheet. Nothing happens when I right click on "Sheet 2". Usually I would see commands such as insert. Additionally, on saved worksheets, when I open them, I cannot add new sheets within already existing worksheets.

I am not an expert, but, I did enable some sort of macro on a excel spreadsheet that was e-mailed to me. Could this have disabled the insert function, etc?

By the way, on different computers, I can use the same files and insert and edit as normal, just not on this one computer.
  • 0

Advertisements


#2
Glaswegian

Glaswegian

    Visiting Staff

  • Visiting Consultant
  • 14 posts
Hi

It does sound as though the right click menu has been disabled - probably via the macros you enabled. This will affect all worksheets opened within Excel, but only on that computer.

You could try running this macro
Sub ResetMenus2()
With Application
    .CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled = True
    .CommandBars("Worksheet Menu Bar").Controls("Edit").Enabled = True
    .CommandBars("Worksheet Menu Bar").Controls("Insert").Enabled = True
    .CommandBars("Tools").Enabled = True
    .CommandBars("Edit").Enabled = True
    .CommandBars("Insert").Enabled = True
    .CommandBars("Ply").Enabled = True
    .CommandBars("cell").Enabled = True
    .CommandBars("Toolbar list").Enabled = True
    .CommandBars.DisableCustomize = False
End With
End Sub

It's my emergency code and will restore all menus etc.

Open Excel and press Alt+F11 to open Visual Basic. I keep this code in my Personal.xls file - if you have one then it should be listed in the left pane. Copy and paste the code into a Module and then run it.
  • 0

#3
statman45

statman45

    New Member

  • Topic Starter
  • Member
  • Pip
  • 3 posts
thanks so much. it worked great. WOW! huge help to me.

thanks again.
  • 0

#4
statman45

statman45

    New Member

  • Topic Starter
  • Member
  • Pip
  • 3 posts
One thing it will not let me do is copy from one cell to another via the right click button. It appears as though I can click on a cell, right click the word "Copy", but, it will not let me paste the contents into another cell.

I assume this is part of me enabling a macro from an excel spreadsheet I received in an e-mail.

Help me, please.
  • 0

#5
Glaswegian

Glaswegian

    Visiting Staff

  • Visiting Consultant
  • 14 posts
Hi again

My code will have reset all right and left click functions as well as menus - perhaps there is something else at work? Is this a different workbook from the last one?
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP