ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Protecting an Excel Sheet name from being changed (https://www.excelbanter.com/excel-programming/304055-protecting-excel-sheet-name-being-changed.html)

[email protected]

Protecting an Excel Sheet name from being changed
 
Hi all, Does anybody know how to Protect an Excel Sheet name from being
changed in VBA? I have several programmically created sheets that I need
to fully protect. Thanks, Mike



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

keepITcool

Protecting an Excel Sheet name from being changed
 
protect workbook = structure

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


wrote:

Hi all, Does anybody know how to Protect an Excel Sheet name from being
changed in VBA? I have several programmically created sheets that I need
to fully protect. Thanks, Mike



*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!




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

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