To prevent a user from deleting and renaming a sheet in a workbook
in [Programming]
|
From: Subodh on 6 Apr 2010 21:53 My code takes the number of sheets and the sheets name as arguments. and i have fixed that. I want to prevent the user from deleting any sheet or renaming them How can i do that? Thanks in advance.
From: Dave Peterson on 6 Apr 2010 22:14 Is it ok to stop them from moving and inserting sheets? If yes, then you could protect the workbook's structure: Tools|Protection|protect workbook (in xl2003 menus) Subodh wrote: > > My code takes the number of sheets and the sheets name as arguments. > and i have fixed that. > I want to prevent the user from deleting any sheet or renaming them > How can i do that? > Thanks in advance. -- Dave Peterson
From: ozgrid.com on 6 Apr 2010 22:25 You should always use Sheet CodeNames when working with sheets. http://www.ozgrid.com/VBA/excel-vba-sheet-names.htm -- Regards Dave Hawley www.ozgrid.com "Dave Peterson" <petersod(a)verizonXSPAM.net> wrote in message news:4BBBEA96.A5BD873F(a)verizonXSPAM.net... > Is it ok to stop them from moving and inserting sheets? > > If yes, then you could protect the workbook's structure: > Tools|Protection|protect workbook > (in xl2003 menus) > > Subodh wrote: >> >> My code takes the number of sheets and the sheets name as arguments. >> and i have fixed that. >> I want to prevent the user from deleting any sheet or renaming them >> How can i do that? >> Thanks in advance. > > -- > > Dave Peterson
From: Dave Peterson on 7 Apr 2010 08:32 That's not always possible. "ozgrid.com" wrote: > > You should always use Sheet CodeNames when working with sheets. > http://www.ozgrid.com/VBA/excel-vba-sheet-names.htm > -- > Regards > Dave Hawley > www.ozgrid.com > "Dave Peterson" <petersod(a)verizonXSPAM.net> wrote in message > news:4BBBEA96.A5BD873F(a)verizonXSPAM.net... > > Is it ok to stop them from moving and inserting sheets? > > > > If yes, then you could protect the workbook's structure: > > Tools|Protection|protect workbook > > (in xl2003 menus) > > > > Subodh wrote: > >> > >> My code takes the number of sheets and the sheets name as arguments. > >> and i have fixed that. > >> I want to prevent the user from deleting any sheet or renaming them > >> How can i do that? > >> Thanks in advance. > > > > -- > > > > Dave Peterson -- Dave Peterson
|
Pages: 1 Prev: Macro to copy subtotaled data Next: simple macro to compare lists |