is it possible to unable the user to add more sheets to a workboo

Posted to microsoft.public.excel.programming

jjk

external usenet poster

Posts: 42

is it possible to unable the user to add more sheets to a workboo

Using menu Goto
Tools - Protection - Protect Workbook
Make sure Structure is checked.

Programatically
ThisWorkbook.Protect Structu=True

Regards,
Jayant

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Unable to select sheets when maximized	Horatio J. Bilge, Jr.	Excel Discussion (Misc queries)	0	November 12th 09 02:01 PM
How to keep font color when referencing Sheets in the same workboo	AdirondackSam	Excel Worksheet Functions	4	September 11th 08 01:14 AM
how do i link one sheet to another sheets cell of the same workboo	MANDAR	Excel Discussion (Misc queries)	1	May 14th 08 08:35 AM
Can columns be hidden accross multiple sheets in an Excel workboo	Ray Naylor	Excel Worksheet Functions	11	September 30th 06 07:38 AM
Unable to add user-defined data types to a collection	Adrian[_7_]	Excel Programming	3	July 14th 04 08:01 PM

All times are GMT +1. The time now is 02:04 AM.

Menu

About Us