Spreadsheet Tab Options

[pedroghuk]

This has got to be easy!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I use Excel 2003.<o></o>
On the actual spreadsheet tabs (Sheet1, Sheet2, Sheet3 ...), I am unable to utilise the Insert, Delete, Rename, Move or Copy commands. They are greyed out. The Select All option is available.<o></o>
The actual Workbook is protected to open and modify.<o></o>
The attributes and permissions to the Workbook look fine.<o></o>
If there something in Tools -> Options, I should be aware off?<o></o>
Any help will be gratefully received.<o></o>
<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1lace w:st="on"><st1:City w:st="on">Gary</st1:City></st1lace><o></o>
<o> </o>

 

[Richard Schollar]

Hi Gary

Do you have workbook protection applied via Tools>Protection>Protect Workbook?

 

[pedroghuk]

Richard<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Good morning.<o></o>
<o></o>
No, I applied the protection using Save As -> goto Tools tab in the Save As screen and clicked on General Options.<o></o>
<o></o>
I understand this is the same as utilising Tools -> Options -> Security within the actual Workbook.<o></o>
<o></o>
Regards.<o></o>
<o></o>
<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1:City w:st="on"><st1lace w:st="on">Gary</st1lace></st1:City><o></o>
<o> </o>

 

[Richard Schollar]

Can you check that someone hasn't inadvertantly applied workbook protection though - if you go Tools>Protection it should be obvious as it will have "Unprotect Workbook" if it is already applied.

 

[pedroghuk]

Richard
Sorted!
The Workbook was protected by someone in error!!!
Makes sense that the commands were unavailable.
Thanks for your prompt response.
Gary