ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Protect Help! (https://www.excelbanter.com/excel-programming/339176-protect-help.html)

lehainam[_20_]

Protect Help!
 

Dear all,

I have a workbook having 02 sheets: data and form. Is there any way to
prevent user changing worksheet name without using protect sheet.

Thanks a lot!

Nam


--
lehainam
------------------------------------------------------------------------
lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615
View this thread: http://www.excelforum.com/showthread...hreadid=401854


Earl Kiosterud

Protect Help!
 
lehainam,

Protecting the sheet doesn't prevent the changing of a sheet name.
Protecting the workbook (Tools - Protect - Protect Workbook) does, and
allows changes to the sheets.
--
Earl Kiosterud
www.smokeylake.com

"lehainam" wrote in
message ...

Dear all,

I have a workbook having 02 sheets: data and form. Is there any way to
prevent user changing worksheet name without using protect sheet.

Thanks a lot!

Nam


--
lehainam
------------------------------------------------------------------------
lehainam's Profile:
http://www.excelforum.com/member.php...o&userid=18615
View this thread: http://www.excelforum.com/showthread...hreadid=401854





All times are GMT +1. The time now is 01:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com