| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
prevent user to rename sheet
Is there a way to prevent user to rename a sheet?
Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
prevent user to rename sheet
Hi
protect the workbook ('tools - Protection') -----Original Message----- Is there a way to prevent user to rename a sheet? Thanks . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
prevent user to rename sheet
yes of course. SOrry I should ahve said that I cannot
protect the workbook because I want to be able to add sheets. Is there a code I could use? -----Original Message----- Hi protect the workbook ('tools - Protection') -----Original Message----- Is there a way to prevent user to rename a sheet? Thanks . . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
prevent user to rename sheet
Hi
then it's getting difficult. You may consider protection the workbook and creating a macro for sheet insertions. This macro first unprotects the workbook, insertes the sheet and the protect the workbook gain. -----Original Message----- yes of course. SOrry I should ahve said that I cannot protect the workbook because I want to be able to add sheets. Is there a code I could use? -----Original Message----- Hi protect the workbook ('tools - Protection') -----Original Message----- Is there a way to prevent user to rename a sheet? Thanks . . . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
prevent user to rename sheet
You might also want to consider why you don't want the sheets renamed. If it
is because your code refers to the sheet name, then use codename. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Frank Kabel" wrote in message ... Hi then it's getting difficult. You may consider protection the workbook and creating a macro for sheet insertions. This macro first unprotects the workbook, insertes the sheet and the protect the workbook gain. -----Original Message----- yes of course. SOrry I should ahve said that I cannot protect the workbook because I want to be able to add sheets. Is there a code I could use? -----Original Message----- Hi protect the workbook ('tools - Protection') -----Original Message----- Is there a way to prevent user to rename a sheet? Thanks . . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i rename a sheet if the rename tab is inactive? | Excel Worksheet Functions | |||
| Prevent user from using Name | Excel Discussion (Misc queries) | |||
| Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
| Prevent User to unlock Sheet Tabs | Excel Worksheet Functions | |||
| How to Prevent User from Unhiding Sheet | Excel Programming | |||
Linear Mode
