PC Review


Reply
Thread Tools Rate Thread

How to disable the insert worksheet(Shift+F11) icon in 2007 using

 
 
=?Utf-8?B?c2c=?=
Guest
Posts: n/a
 
      24th Jul 2007
Excel 2007 has a new icon next to the Sheet names to add a new worksheet.
How can we disable / invisible, so that user can not add a new sheet.

Thanks.
 
Reply With Quote
 
 
 
 
Harlan Grove
Guest
Posts: n/a
 
      25th Jul 2007
"sg" <(E-Mail Removed)> wrote...
>Excel 2007 has a new icon next to the Sheet names to add a new worksheet.
>How can we disable / invisible, so that user can not add a new sheet.


Why not protect the workBOOK so users can't add or remove worksheets?


 
Reply With Quote
 
=?Utf-8?B?c2c=?=
Guest
Posts: n/a
 
      26th Jul 2007
We are programmatically hide/unhide certain sheets, that doesn't work if we
protect workbook. May be we need to unprotect worksbook, then do the
hide/unhide and then protect it back.

I was thinking may be there's another way I can hide that icon.

Thanks for your reply.

"Harlan Grove" wrote:

> "sg" <(E-Mail Removed)> wrote...
> >Excel 2007 has a new icon next to the Sheet names to add a new worksheet.
> >How can we disable / invisible, so that user can not add a new sheet.

>
> Why not protect the workBOOK so users can't add or remove worksheets?
>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
insert worksheet shift 11 tab sammy Microsoft Excel Programming 2 29th Apr 2011 03:49 PM
Why is Paste in Word 2007 Shift-Insert? RBM-TAX Microsoft Word Document Management 1 24th Feb 2010 09:45 PM
Word 2007 Insert Time (Alt+Shift+T) - Disable AutoUpdate Bradley Microsoft Word Document Management 7 2nd May 2009 08:06 AM
Disable Shift Key in Access 2007? =?Utf-8?B?SmFzb24gQnJhZHk=?= Microsoft Access Security 2 28th Dec 2006 09:47 AM
Disable Shift+F10 & context menu key in worksheet Lurc Microsoft Excel Discussion 2 23rd May 2005 06:45 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:03 AM.