PDA

View Full Version : Fixing worksheet in place



shankar
03-28-2009, 06:32 AM
Hi, I am new to VBA for Excel, I have one question. I need to make sure that the first sheet stays as the first tab always, even when the user tries to drag it or another sheet and change the order. Also the user should not be able to delete the first sheet by right clicking its tab. However the user should be able to change the order of the rest of the sheets or insert or delete new sheets just like it is by default. Any suggestions welcome. Thanks.

Shankar

shankar
03-28-2009, 06:58 AM
A related note, even when I protect the sheet under the "Review" pane of the ribbon, it still allows me to delete the sheet even though I cannot make changes to it. This baffles me. Is there a simple way to protect a sheet unconditionally? I am using Excel 2007. Thanks.

Shankar

mdmackillop
03-28-2009, 07:31 AM
You can protect the Workbook, but this does not appear to allow normal reordering of other sheets.